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, det.discount_type, det.discount_value, det.discount_currency, 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.vendor_auth_qty, 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, hdr_attr_catg, hdr_attr1, hdr_attr2, hdr_attr3, hdr_attr4, hdr_attr5, hdr_attr6, hdr_attr7, hdr_attr8, hdr_attr9, hdr_attr10, hdr_attr11, hdr_attr12, hdr_attr13, hdr_attr14, hdr_attr15, hdr_attr16, hdr_attr17, hdr_attr18, hdr_attr19, hdr_attr20, hdr_attr21, hdr_attr22, hdr_attr23, hdr_attr24, hdr_attr25, hdr_attr26, hdr_attr27, hdr_attr28, hdr_attr29, hdr_attr30, line_attr_catg, line_attr1, line_attr2, line_attr3, line_attr4, line_attr5, line_attr6, line_attr7, line_attr8, line_attr9, line_attr10, line_attr11, line_attr12, line_attr13, line_attr14, line_attr15, line_attr16, line_attr17, line_attr18, line_attr19, line_attr20, line_attr21, line_attr22, line_attr23, line_attr24, line_attr25, line_attr26, line_attr27, line_attr28, line_attr29, line_attr30 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
, DET.DISCOUNT_TYPE
, DET.DISCOUNT_VALUE
, DET.DISCOUNT_CURRENCY
, 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.VENDOR_AUTH_QTY
, 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
, HDR_ATTR_CATG
, HDR_ATTR1
, HDR_ATTR2
, HDR_ATTR3
, HDR_ATTR4
, HDR_ATTR5
, HDR_ATTR6
, HDR_ATTR7
, HDR_ATTR8
, HDR_ATTR9
, HDR_ATTR10
, HDR_ATTR11
, HDR_ATTR12
, HDR_ATTR13
, HDR_ATTR14
, HDR_ATTR15
, HDR_ATTR16
, HDR_ATTR17
, HDR_ATTR18
, HDR_ATTR19
, HDR_ATTR20
, HDR_ATTR21
, HDR_ATTR22
, HDR_ATTR23
, HDR_ATTR24
, HDR_ATTR25
, HDR_ATTR26
, HDR_ATTR27
, HDR_ATTR28
, HDR_ATTR29
, HDR_ATTR30
, LINE_ATTR_CATG
, LINE_ATTR1
, LINE_ATTR2
, LINE_ATTR3
, LINE_ATTR4
, LINE_ATTR5
, LINE_ATTR6
, LINE_ATTR7
, LINE_ATTR8
, LINE_ATTR9
, LINE_ATTR10
, LINE_ATTR11
, LINE_ATTR12
, LINE_ATTR13
, LINE_ATTR14
, LINE_ATTR15
, LINE_ATTR16
, LINE_ATTR17
, LINE_ATTR18
, LINE_ATTR19
, LINE_ATTR20
, LINE_ATTR21
, LINE_ATTR22
, LINE_ATTR23
, LINE_ATTR24
, LINE_ATTR25
, LINE_ATTR26
, LINE_ATTR27
, LINE_ATTR28
, LINE_ATTR29
, LINE_ATTR30
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