Product: | AS - Sales Foundation |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.AS_IMP_SL_V |
SELECT ROWID
, ADDR_DO_NOT_MAIL_FLAG
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, ADDRESS_ID
, ADDRESS_KEY
, ADDRESS_STATUS
, ANALYSIS_FY
, AREA_CODE
, BATCH_ID
, BUDGET_AMOUNT
, BUDGET_AMOUNT_1
, BUDGET_AMOUNT_2
, BUDGET_AMOUNT_3
, BUDGET_AMOUNT_4
, BUDGET_AMOUNT_5
, BUDGET_STATUS_CODE
, CHANNEL_CODE
, CITY
, CLOSE_REASON
, COMPETITOR_FLAG
, CONFIRMED_FLAG
, CONTACT_KEY
, CONTACT_PARTY_ID
, CONTACT_ROLE_CODE
, CONT_DO_NOT_MAIL_FLAG
, COUNTRY
, COUNTY
, CREATED_BY
, CREATION_DATE
, CURRENCY_CODE
, CUSTOMER_CATEGORY_CODE
, CUSTOMER_CLASS_CODE
, CUSTOMER_GROUP_CODE
, CUSTOMER_ID
, CUSTOMER_KEY
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_PROSPECT_CODE
, CUSTOMER_RANK
, CUSTOMER_STATUS
, CUSTOMER_SUBGROUP_CODE
, CUSTOMER_TYPE
, DECISION_TIMEFRAME_CODE
, DESCRIPTION
, DO_NOT_EMAIL_FLAG
, DO_NOT_FAX_FLAG
, DO_NOT_PHONE_FLAG
, EMAIL_ADDRESS
, EXTENSION
, FAX_AREA_CODE
, FAX_NUMBER
, FIRST_NAME
, FISCAL_YEAREND_MONTH
, IMP_LIST_HEADER_NUMBER
, IMPORT_INTERFACE_ID
, INCUMBENT_PARTNER_PARTY_ID
, INCUMBENT_PARTNER_RESOURCE_ID
, INITIATING_CONTACT_ID
, INTEREST_TYPE_ID_1
, INTEREST_TYPE_ID_2
, INTEREST_TYPE_ID_3
, INTEREST_TYPE_ID_4
, INTEREST_TYPE_ID_5
, INVENTORY_ITEM_ID_1
, INVENTORY_ITEM_ID_2
, INVENTORY_ITEM_ID_3
, INVENTORY_ITEM_ID_4
, INVENTORY_ITEM_ID_5
, JOB_TITLE
, JOB_TITLE_CODE
, LAST_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LEAD_NOTE
, LEAD_NUMBER
, LEAD_RANK_CODE
, LEAD_RANK_ID
, LOAD_DATE
, LOAD_ERROR_MESSAGE
, LOAD_STATUS
, LOAD_TYPE
, LOCATION_ID
, MAIL_STOP
, MIDDLE_INITIAL
, NET_WORTH
, NEW_CON_FLAG
, NEW_LOC_FLAG
, NEW_PARTY_FLAG
, NEW_PS_FLAG
, NEW_REL_FLAG
, NUM_ATTENDED
, NUM_ENROLLED
, NUM_OF_EMPLOYEES
, OFFER_ID
, ORGANIZATION_ID_1
, ORGANIZATION_ID_2
, ORGANIZATION_ID_3
, ORGANIZATION_ID_4
, ORGANIZATION_ID_5
, ORIG_SYSTEM_CODE
, ORIG_SYSTEM_REFERENCE
, PARENT_PROJECT
, PARTY_ID
, PARTY_SITE_ID
, PARTY_TYPE
, PAYMENT_AMOUNT
, PHONE_ID
, PHONE_NUMBER
, PHONE_STATUS
, PHONE_TYPE
, POSTAL_CODE
, POTENTIAL_REVENUE_CURR_FY
, POTENTIAL_REVENUE_NEXT_FY
, PRIMARY_INTEREST_CODE_ID_1
, PRIMARY_INTEREST_CODE_ID_2
, PRIMARY_INTEREST_CODE_ID_3
, PRIMARY_INTEREST_CODE_ID_4
, PRIMARY_INTEREST_CODE_ID_5
, PRM_EXEC_SPONSOR_FLAG
, PRM_IND_CLASSIFICATION_CODE
, PRM_PRJ_LEAD_IN_PLACE_FLAG
, PRM_SALES_LEAD_TYPE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROMOTION_CODE
, PROMOTION_ID
, PROMOTION_NAME
, PROVINCE
, QUANTITY_1
, QUANTITY_2
, QUANTITY_3
, QUANTITY_4
, QUANTITY_5
, REFERENCE_USE_FLAG
, REL_PARTY_ID
, REQUEST_ID
, SALES_CHANNEL_CODE
, SALES_LEAD_ID
, SALUTATION
, SECONDARY_INTEREST_CODE_ID_1
, SECONDARY_INTEREST_CODE_ID_2
, SECONDARY_INTEREST_CODE_ID_3
, SECONDARY_INTEREST_CODE_ID_4
, SECONDARY_INTEREST_CODE_ID_5
, NULL
, SEX_CODE
, SIC_CODE
, SITE_CONTACT_ID
, SOURCE_PROMOTION_ID
, SOURCE_SYSTEM
, STATE
, STATUS_CHANGE_FLAG
, STATUS_CODE
, STATUS_CODE_1
, STATUS_CODE_2
, STATUS_CODE_3
, STATUS_CODE_4
, STATUS_CODE_5
, TAX_CODE
, TAX_REFERENCE
, THIRD_PARTY_FLAG
, TITLE
, UOM_CODE_1
, UOM_CODE_2
, UOM_CODE_3
, UOM_CODE_4
, UOM_CODE_5
, URL
, VEHICLE_RESPONSE_CODE
, YEAR_ESTABLISHED
, PARTY_ID
, LAST_UPDATE_DATE
, LOCATION_ID
, PARTY_SITE_ID
, URGENT_FLAG
FROM AS_IMPORT_INTERFACE
WHERE LOAD_STATUS = 'NEW'