VIEW: APPS.OZF_SD_BATCH_CONTENT_QUERY_V

Source

View Text - Preformatted

SELECT frm.batch_number batch_number, frm.org_id operating_unit, frm_contact1_name, frm_contact1_email, frm_contact1_fax, frm_contact1_phone, frm_global_ptnr_role_class_cd frm_gbl_ptnr_role_class_cd, frm_global_business_id frm_gbl_business_id, frm_global_supply_chain_cd frm_gbl_supply_chain_cd, frm_business_name, frm_prop_business_id, frm_prop_domain_id1, frm_prop_auth_id1, frm_global_partner_class_code frm_gbl_ptnr_class_code, frm_contact2_name, frm_contact2_email, frm_contact2_fax, frm_contact2_phone, frm_global_location_id frm_gbl_loc_id, frm_prop_domain_id2, frm_prop_auth_id2, frm_prop_loc_id, frm_add_line1, frm_add_line2, frm_add_line3, frm_city, frm_country, frm_postal_code, frm_box_identifier frm_box_id, frm_state_region, FND_MESSAGE.GET_STRING('OZF','OZF_SDB_GBL_DOC_FUNC_CODE_REQ') gbl_doc_func_cd, ship_frm_sd_authorization_id, dist_by_gbl_business_id, dist_by_gbl_supply_chain_code, dist_by_business_name, dist_by_prop_business_id, dist_by_prop_domain_id1, dist_by_prop_auth_id1, dist_by_gbl_partner_class_code dist_by_gbl_ptnr_class_code, dist_by_contact1_name, dist_by_contact1_email, dist_by_contact1_fax, dist_by_contact1_phone, dist_by_gbl_location_id, dist_by_prop_domain_id2, dist_by_prop_idauthority2, dist_by_prop_location_id, dist_by_address_line1 dist_by_add_line1, dist_by_address_line2 dist_by_add_line2, dist_by_address_line3 dist_by_add_line3, dist_by_city_name, dist_by_gbl_country_code, dist_by_national_postal_code, dist_by_pobox_id, dist_by_region_name, ship_to_business_name, ship_to_gbl_business_id, ship_to_gbl_supply_chain_code, ship_to_prop_business_id, ship_to_prop_domain_id1, ship_to_prop_id_authority1, ship_to_gbl_partner_class_code ship_to_gbl_ptnr_class_code, ship_to_contact1_name, ship_to_contact1_email, ship_to_contact1_fax, ship_to_contact1_phone, ship_to_gbl_loc_id, ship_to_prop_domain_id2, ship_to_prop_id_authority2, ship_to_prop_loc_id, ship_to_address_line1 ship_to_add_line1, ship_to_address_line2 ship_to_add_line2, ship_to_address_line3 ship_to_add_line3, ship_to_city_name, ship_to_gbl_country_code, ship_to_national_postal_code, ship_to_pobox_id, ship_to_region_name, sold_to_business_name, sold_to_gbl_business_id, sold_to_gbl_supply_chain_code, sold_to_prop_business_id, sold_to_prop_domain_id1, sold_to_prop_id_authority1, sold_to_gbl_partner_class_code sold_to_gbl_ptnr_class_code, sold_to_contact1_name, sold_to_contact1_email, sold_to_contact1_fax, sold_to_contact1_phone, sold_to_gbl_loc_id, sold_to_prop_domain_id2, sold_to_prop_id_authority2, sold_to_prop_loc_id, sold_to_address_line1 sold_to_add_line1, sold_to_address_line2 sold_to_add_line2, sold_to_address_line3 sold_to_add_line3, sold_to_city_name, sold_to_gbl_country_code, sold_to_national_postal_code, sold_to_pobox_id, sold_to_region_name, used_by_business_name, used_by_gbl_business_id, used_by_gbl_supply_chain_code, used_by_prop_business_id, used_by_prop_domain_id1, used_by_prop_id_authority1, used_by_gbl_partner_class_code used_by_gbl_ptnr_class_code, used_by_contact1_name, used_by_contact1_email, used_by_contact1_fax, used_by_contact1_phone, used_by_gbl_loc_id, used_by_prop_domain_id2, used_by_prop_id_authority2, used_by_prop_loc_id, used_by_address_line1 used_by_add_line1, used_by_address_line2 used_by_add_line2, used_by_address_line3 used_by_add_line3, used_by_city_name, used_by_gbl_country_code, used_by_national_postal_code, used_by_pobox_id, used_by_region_name, NULL ship_frm_sd_claim_request_date, NULL ship_frm_sd_claim_request_id, NULL credit_ref_id, debit_reference_id debit_ref_id, batch_line_id, batch_line_number, order_date, order_line_number, order_number, invoice_date, invoice_line_number, invoice_number, cost_currencycode, cost_monetary_amount, auth_cost_currency_code, auth_cost_monetary_amount, resale_currency_code, resale_monetary_amount, gbl_uom, NULL gbl_claim_disposition_code, det.dispute_code1, det.dispute_code2, det.dispute_code3, det.dispute_code4, det.dispute_code5, det.dispute_code6, det.dispute_code7, det.dispute_code8, det.dispute_code9, det.dispute_code10, vendor_product_id, dist_product_id, ship_date, shipped_quantity, det.last_sub_claim_amount, det.claim_amount_currency_code, NULL supp_auth_line_item_number, det.vendor_auth_cost_currency_code, det.vendor_auth_cost_monetary_amt, det.batch_submission_date, frm.batch_id, to_contact1_name, to_contact1_email, to_contact1_fax, to_contact1_phone, to_global_ptnr_role_class_cd to_gbl_ptnr_role_class_cd, to_global_business_id to_gbl_business_id, to_global_supply_chain_cd to_gbl_supply_chain_cd, to_business_name, to_prop_business_id, to_prop_domain_id1, to_prop_auth_id1, to_global_partner_class_code to_gbl_ptnr_class_code, to_contact2_name, to_contact2_email, to_contact2_fax, to_contact2_phone, to_global_location_id to_gbl_loc_id, to_prop_domain_id2, to_prop_auth_id2, to_prop_loc_id, to_add_line1, to_add_line2, to_add_line3, to_city, to_country, to_postal_code, to_box_identifier to_box_id, to_state_region FROM ozf_sd_batch_from_role_v frm, ozf_sd_batch_info_v det, ozf_sd_batch_to_role_v to_rl WHERE det.this_doc_id = to_rl.batch_id AND frm.batch_id = to_rl.batch_id

View Text - HTML Formatted

SELECT FRM.BATCH_NUMBER BATCH_NUMBER
, FRM.ORG_ID OPERATING_UNIT
, FRM_CONTACT1_NAME
, FRM_CONTACT1_EMAIL
, FRM_CONTACT1_FAX
, FRM_CONTACT1_PHONE
, FRM_GLOBAL_PTNR_ROLE_CLASS_CD FRM_GBL_PTNR_ROLE_CLASS_CD
, FRM_GLOBAL_BUSINESS_ID FRM_GBL_BUSINESS_ID
, FRM_GLOBAL_SUPPLY_CHAIN_CD FRM_GBL_SUPPLY_CHAIN_CD
, FRM_BUSINESS_NAME
, FRM_PROP_BUSINESS_ID
, FRM_PROP_DOMAIN_ID1
, FRM_PROP_AUTH_ID1
, FRM_GLOBAL_PARTNER_CLASS_CODE FRM_GBL_PTNR_CLASS_CODE
, FRM_CONTACT2_NAME
, FRM_CONTACT2_EMAIL
, FRM_CONTACT2_FAX
, FRM_CONTACT2_PHONE
, FRM_GLOBAL_LOCATION_ID FRM_GBL_LOC_ID
, FRM_PROP_DOMAIN_ID2
, FRM_PROP_AUTH_ID2
, FRM_PROP_LOC_ID
, FRM_ADD_LINE1
, FRM_ADD_LINE2
, FRM_ADD_LINE3
, FRM_CITY
, FRM_COUNTRY
, FRM_POSTAL_CODE
, FRM_BOX_IDENTIFIER FRM_BOX_ID
, FRM_STATE_REGION
, FND_MESSAGE.GET_STRING('OZF'
, 'OZF_SDB_GBL_DOC_FUNC_CODE_REQ') GBL_DOC_FUNC_CD
, SHIP_FRM_SD_AUTHORIZATION_ID
, DIST_BY_GBL_BUSINESS_ID
, DIST_BY_GBL_SUPPLY_CHAIN_CODE
, DIST_BY_BUSINESS_NAME
, DIST_BY_PROP_BUSINESS_ID
, DIST_BY_PROP_DOMAIN_ID1
, DIST_BY_PROP_AUTH_ID1
, DIST_BY_GBL_PARTNER_CLASS_CODE DIST_BY_GBL_PTNR_CLASS_CODE
, DIST_BY_CONTACT1_NAME
, DIST_BY_CONTACT1_EMAIL
, DIST_BY_CONTACT1_FAX
, DIST_BY_CONTACT1_PHONE
, DIST_BY_GBL_LOCATION_ID
, DIST_BY_PROP_DOMAIN_ID2
, DIST_BY_PROP_IDAUTHORITY2
, DIST_BY_PROP_LOCATION_ID
, DIST_BY_ADDRESS_LINE1 DIST_BY_ADD_LINE1
, DIST_BY_ADDRESS_LINE2 DIST_BY_ADD_LINE2
, DIST_BY_ADDRESS_LINE3 DIST_BY_ADD_LINE3
, DIST_BY_CITY_NAME
, DIST_BY_GBL_COUNTRY_CODE
, DIST_BY_NATIONAL_POSTAL_CODE
, DIST_BY_POBOX_ID
, DIST_BY_REGION_NAME
, SHIP_TO_BUSINESS_NAME
, SHIP_TO_GBL_BUSINESS_ID
, SHIP_TO_GBL_SUPPLY_CHAIN_CODE
, SHIP_TO_PROP_BUSINESS_ID
, SHIP_TO_PROP_DOMAIN_ID1
, SHIP_TO_PROP_ID_AUTHORITY1
, SHIP_TO_GBL_PARTNER_CLASS_CODE SHIP_TO_GBL_PTNR_CLASS_CODE
, SHIP_TO_CONTACT1_NAME
, SHIP_TO_CONTACT1_EMAIL
, SHIP_TO_CONTACT1_FAX
, SHIP_TO_CONTACT1_PHONE
, SHIP_TO_GBL_LOC_ID
, SHIP_TO_PROP_DOMAIN_ID2
, SHIP_TO_PROP_ID_AUTHORITY2
, SHIP_TO_PROP_LOC_ID
, SHIP_TO_ADDRESS_LINE1 SHIP_TO_ADD_LINE1
, SHIP_TO_ADDRESS_LINE2 SHIP_TO_ADD_LINE2
, SHIP_TO_ADDRESS_LINE3 SHIP_TO_ADD_LINE3
, SHIP_TO_CITY_NAME
, SHIP_TO_GBL_COUNTRY_CODE
, SHIP_TO_NATIONAL_POSTAL_CODE
, SHIP_TO_POBOX_ID
, SHIP_TO_REGION_NAME
, SOLD_TO_BUSINESS_NAME
, SOLD_TO_GBL_BUSINESS_ID
, SOLD_TO_GBL_SUPPLY_CHAIN_CODE
, SOLD_TO_PROP_BUSINESS_ID
, SOLD_TO_PROP_DOMAIN_ID1
, SOLD_TO_PROP_ID_AUTHORITY1
, SOLD_TO_GBL_PARTNER_CLASS_CODE SOLD_TO_GBL_PTNR_CLASS_CODE
, SOLD_TO_CONTACT1_NAME
, SOLD_TO_CONTACT1_EMAIL
, SOLD_TO_CONTACT1_FAX
, SOLD_TO_CONTACT1_PHONE
, SOLD_TO_GBL_LOC_ID
, SOLD_TO_PROP_DOMAIN_ID2
, SOLD_TO_PROP_ID_AUTHORITY2
, SOLD_TO_PROP_LOC_ID
, SOLD_TO_ADDRESS_LINE1 SOLD_TO_ADD_LINE1
, SOLD_TO_ADDRESS_LINE2 SOLD_TO_ADD_LINE2
, SOLD_TO_ADDRESS_LINE3 SOLD_TO_ADD_LINE3
, SOLD_TO_CITY_NAME
, SOLD_TO_GBL_COUNTRY_CODE
, SOLD_TO_NATIONAL_POSTAL_CODE
, SOLD_TO_POBOX_ID
, SOLD_TO_REGION_NAME
, USED_BY_BUSINESS_NAME
, USED_BY_GBL_BUSINESS_ID
, USED_BY_GBL_SUPPLY_CHAIN_CODE
, USED_BY_PROP_BUSINESS_ID
, USED_BY_PROP_DOMAIN_ID1
, USED_BY_PROP_ID_AUTHORITY1
, USED_BY_GBL_PARTNER_CLASS_CODE USED_BY_GBL_PTNR_CLASS_CODE
, USED_BY_CONTACT1_NAME
, USED_BY_CONTACT1_EMAIL
, USED_BY_CONTACT1_FAX
, USED_BY_CONTACT1_PHONE
, USED_BY_GBL_LOC_ID
, USED_BY_PROP_DOMAIN_ID2
, USED_BY_PROP_ID_AUTHORITY2
, USED_BY_PROP_LOC_ID
, USED_BY_ADDRESS_LINE1 USED_BY_ADD_LINE1
, USED_BY_ADDRESS_LINE2 USED_BY_ADD_LINE2
, USED_BY_ADDRESS_LINE3 USED_BY_ADD_LINE3
, USED_BY_CITY_NAME
, USED_BY_GBL_COUNTRY_CODE
, USED_BY_NATIONAL_POSTAL_CODE
, USED_BY_POBOX_ID
, USED_BY_REGION_NAME
, NULL SHIP_FRM_SD_CLAIM_REQUEST_DATE
, NULL SHIP_FRM_SD_CLAIM_REQUEST_ID
, NULL CREDIT_REF_ID
, DEBIT_REFERENCE_ID DEBIT_REF_ID
, BATCH_LINE_ID
, BATCH_LINE_NUMBER
, ORDER_DATE
, ORDER_LINE_NUMBER
, ORDER_NUMBER
, INVOICE_DATE
, INVOICE_LINE_NUMBER
, INVOICE_NUMBER
, COST_CURRENCYCODE
, COST_MONETARY_AMOUNT
, AUTH_COST_CURRENCY_CODE
, AUTH_COST_MONETARY_AMOUNT
, RESALE_CURRENCY_CODE
, RESALE_MONETARY_AMOUNT
, GBL_UOM
, NULL GBL_CLAIM_DISPOSITION_CODE
, DET.DISPUTE_CODE1
, DET.DISPUTE_CODE2
, DET.DISPUTE_CODE3
, DET.DISPUTE_CODE4
, DET.DISPUTE_CODE5
, DET.DISPUTE_CODE6
, DET.DISPUTE_CODE7
, DET.DISPUTE_CODE8
, DET.DISPUTE_CODE9
, DET.DISPUTE_CODE10
, VENDOR_PRODUCT_ID
, DIST_PRODUCT_ID
, SHIP_DATE
, SHIPPED_QUANTITY
, DET.LAST_SUB_CLAIM_AMOUNT
, DET.CLAIM_AMOUNT_CURRENCY_CODE
, NULL SUPP_AUTH_LINE_ITEM_NUMBER
, DET.VENDOR_AUTH_COST_CURRENCY_CODE
, DET.VENDOR_AUTH_COST_MONETARY_AMT
, DET.BATCH_SUBMISSION_DATE
, FRM.BATCH_ID
, TO_CONTACT1_NAME
, TO_CONTACT1_EMAIL
, TO_CONTACT1_FAX
, TO_CONTACT1_PHONE
, TO_GLOBAL_PTNR_ROLE_CLASS_CD TO_GBL_PTNR_ROLE_CLASS_CD
, TO_GLOBAL_BUSINESS_ID TO_GBL_BUSINESS_ID
, TO_GLOBAL_SUPPLY_CHAIN_CD TO_GBL_SUPPLY_CHAIN_CD
, TO_BUSINESS_NAME
, TO_PROP_BUSINESS_ID
, TO_PROP_DOMAIN_ID1
, TO_PROP_AUTH_ID1
, TO_GLOBAL_PARTNER_CLASS_CODE TO_GBL_PTNR_CLASS_CODE
, TO_CONTACT2_NAME
, TO_CONTACT2_EMAIL
, TO_CONTACT2_FAX
, TO_CONTACT2_PHONE
, TO_GLOBAL_LOCATION_ID TO_GBL_LOC_ID
, TO_PROP_DOMAIN_ID2
, TO_PROP_AUTH_ID2
, TO_PROP_LOC_ID
, TO_ADD_LINE1
, TO_ADD_LINE2
, TO_ADD_LINE3
, TO_CITY
, TO_COUNTRY
, TO_POSTAL_CODE
, TO_BOX_IDENTIFIER TO_BOX_ID
, TO_STATE_REGION
FROM OZF_SD_BATCH_FROM_ROLE_V FRM
, OZF_SD_BATCH_INFO_V DET
, OZF_SD_BATCH_TO_ROLE_V TO_RL
WHERE DET.THIS_DOC_ID = TO_RL.BATCH_ID
AND FRM.BATCH_ID = TO_RL.BATCH_ID