DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 3403: , hz_cust_site_uses_all ssu

3399: , l_inventory_item_id
3400: FROM
3401: oe_order_lines_all ol
3402: , hz_cust_acct_sites_all ss
3403: , hz_cust_site_uses_all ssu
3404: , hz_cust_acct_sites_all bs
3405: , hz_cust_site_uses_all bsu
3406: WHERE ol.line_id=p_oe_order_line_id
3407: and ol.ship_to_org_id = ssu.site_use_id (+)

Line 3405: , hz_cust_site_uses_all bsu

3401: oe_order_lines_all ol
3402: , hz_cust_acct_sites_all ss
3403: , hz_cust_site_uses_all ssu
3404: , hz_cust_acct_sites_all bs
3405: , hz_cust_site_uses_all bsu
3406: WHERE ol.line_id=p_oe_order_line_id
3407: and ol.ship_to_org_id = ssu.site_use_id (+)
3408: and ssu.site_use_code = 'SHIP_TO'
3409: and ol.invoice_to_org_id = bsu.site_use_id (+)