VIEW: APPS.AS_IMP_SL_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'