DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 3404: , hz_cust_site_uses_all ssu

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

Line 3406: , hz_cust_site_uses_all bsu

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