Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122

    Unanswered: oracle Apps select help needed

    Problem Solved. I left application_id out of the join.

    Can someone please explain why the results of a describe on table AS_CUST_PROFILES
    gives different results than a select using apps.fnd_tables and apps.fnd_columns?

    Code:
    SQL> SELECT a.application_id, A.table_id, b.table_name, a.column_id, a.column_name
            FROM apps.fnd_columns a,
            apps.fnd_tables b
            WHERE
            (
            column_name LIKE 'SSN%' OR
            column_name LIKE 'SUPPL%' OR
            column_name LIKE 'EMPL%' OR
            column_name LIKE 'TAX_ID%' OR
            column_name LIKE 'BANK%'
            )
            AND a.TABLE_ID = 59847
            AND b.TABLE_NAME = 'AS_CUST_PROFILES';
    
    8301  59847 AS_CUST_PROFILES      293787 EMPLOYEE_ASSIGNMENT_ID
    8301  59847 AS_CUST_PROFILES      293788 EMPLOYEE_DATE_OF_BIRTH
    8301  59847 AS_CUST_PROFILES      293789 EMPLOYEE_DEPT_OR_AGENCY
    8301  59847 AS_CUST_PROFILES      293790 EMPLOYEE_FIRST_NAME
    8301  59847 AS_CUST_PROFILES      293791 EMPLOYEE_LAST_NAME 
    8301  59847 AS_CUST_PROFILES      293792 EMPLOYEE_MIDDLE_NAMES
    8301  59847 AS_CUST_PROFILES      293793 EMPLOYEE_NATIONAL_IDENTIFIER
    
    7 rows selected.
    Code:
    SQL> desc AS_CUST_PROFILES;
     Name                            Null?    Type
     ------------------------------- -------- ----
     CUSTOMER_ID                     NOT NULL NUMBER
     ADDRESS_ID                      NOT NULL NUMBER
     CREATED_BY                      NOT NULL NUMBER
     CREATION_DATE                   NOT NULL DATE
     LAST_UPDATED_BY                 NOT NULL NUMBER
     LAST_UPDATE_DATE                NOT NULL DATE
     LAST_UPDATE_LOGIN               NOT NULL NUMBER
    
    SQL>
    Last edited by wrwelden; 12-07-06 at 11:07.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking


    Is your problem solved or is there still a question linging around here?

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122
    problem solved. thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •