VIEW: APPS.OZF_SD_BATCH_TO_ROLE_V

Source

View Text - Preformatted

SELECT hdr_to.vendor_id vendor_id, hdr_to.vendor_site_id vendor_site_id, hdr_to.vendor_contact_id vendor_contact_id, hdr_to.org_id org_id, hdr_to.batch_number batch_number, hdr_to.batch_id batch_id, hdr_to.vendor_contact_name to_contact1_name, hdr_to.vendor_email to_contact1_email, hdr_to.vendor_phone to_contact1_phone, hdr_to.vendor_fax to_contact1_fax, FND_MESSAGE.GET_STRING('OZF','OZF_SDB_TO_GBL_PTNR_ROLE_CODE') to_global_ptnr_role_class_cd, aps.vendor_name to_business_name, nvl(apss.duns_number, 0) to_global_business_id, hzp.category_code to_global_supply_chain_cd, NULL to_prop_business_id, NULL to_prop_domain_id1, NULL to_prop_auth_id1, FND_MESSAGE.GET_STRING('OZF','OZF_SDB_TO_GBL_PTNR_CLASS_CODE') to_global_partner_class_code, hdr_to.vendor_contact_name to_contact2_name, hdr_to.vendor_email to_contact2_email, hdr_to.vendor_phone to_contact2_phone, hdr_to.vendor_fax to_contact2_fax, apss.vendor_site_code to_global_location_id, NULL to_prop_domain_id2, NULL to_prop_auth_id2, NULL to_prop_loc_id, apss.address_line1 to_add_line1, apss.address_line2 to_add_line2, apss.address_line3 to_add_line3, apss.city to_city, apss.country to_country, apss.zip to_postal_code, apss.zip to_box_identifier, apss.state to_state_region FROM ozf_sd_batch_headers_all hdr_to, ap_suppliers aps, ap_supplier_sites_all apss, ap_supplier_contacts apsc, hz_parties hzp WHERE hdr_to.vendor_id = aps.vendor_id AND hdr_to.vendor_site_id = apss.vendor_site_id AND hdr_to.vendor_contact_id = apsc.vendor_contact_id(+) AND aps.party_id = hzp.party_id(+)

View Text - HTML Formatted

SELECT HDR_TO.VENDOR_ID VENDOR_ID
, HDR_TO.VENDOR_SITE_ID VENDOR_SITE_ID
, HDR_TO.VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, HDR_TO.ORG_ID ORG_ID
, HDR_TO.BATCH_NUMBER BATCH_NUMBER
, HDR_TO.BATCH_ID BATCH_ID
, HDR_TO.VENDOR_CONTACT_NAME TO_CONTACT1_NAME
, HDR_TO.VENDOR_EMAIL TO_CONTACT1_EMAIL
, HDR_TO.VENDOR_PHONE TO_CONTACT1_PHONE
, HDR_TO.VENDOR_FAX TO_CONTACT1_FAX
, FND_MESSAGE.GET_STRING('OZF'
, 'OZF_SDB_TO_GBL_PTNR_ROLE_CODE') TO_GLOBAL_PTNR_ROLE_CLASS_CD
, APS.VENDOR_NAME TO_BUSINESS_NAME
, NVL(APSS.DUNS_NUMBER
, 0) TO_GLOBAL_BUSINESS_ID
, HZP.CATEGORY_CODE TO_GLOBAL_SUPPLY_CHAIN_CD
, NULL TO_PROP_BUSINESS_ID
, NULL TO_PROP_DOMAIN_ID1
, NULL TO_PROP_AUTH_ID1
, FND_MESSAGE.GET_STRING('OZF'
, 'OZF_SDB_TO_GBL_PTNR_CLASS_CODE') TO_GLOBAL_PARTNER_CLASS_CODE
, HDR_TO.VENDOR_CONTACT_NAME TO_CONTACT2_NAME
, HDR_TO.VENDOR_EMAIL TO_CONTACT2_EMAIL
, HDR_TO.VENDOR_PHONE TO_CONTACT2_PHONE
, HDR_TO.VENDOR_FAX TO_CONTACT2_FAX
, APSS.VENDOR_SITE_CODE TO_GLOBAL_LOCATION_ID
, NULL TO_PROP_DOMAIN_ID2
, NULL TO_PROP_AUTH_ID2
, NULL TO_PROP_LOC_ID
, APSS.ADDRESS_LINE1 TO_ADD_LINE1
, APSS.ADDRESS_LINE2 TO_ADD_LINE2
, APSS.ADDRESS_LINE3 TO_ADD_LINE3
, APSS.CITY TO_CITY
, APSS.COUNTRY TO_COUNTRY
, APSS.ZIP TO_POSTAL_CODE
, APSS.ZIP TO_BOX_IDENTIFIER
, APSS.STATE TO_STATE_REGION
FROM OZF_SD_BATCH_HEADERS_ALL HDR_TO
, AP_SUPPLIERS APS
, AP_SUPPLIER_SITES_ALL APSS
, AP_SUPPLIER_CONTACTS APSC
, HZ_PARTIES HZP
WHERE HDR_TO.VENDOR_ID = APS.VENDOR_ID
AND HDR_TO.VENDOR_SITE_ID = APSS.VENDOR_SITE_ID
AND HDR_TO.VENDOR_CONTACT_ID = APSC.VENDOR_CONTACT_ID(+)
AND APS.PARTY_ID = HZP.PARTY_ID(+)