DBA Data[Home] [Help]

APPS.POS_ASN_NOTIF dependencies on HZ_LOCATIONS

Line 685: hr_locations_all_tl hrl, hz_locations hz

681: ood.ORGANIZATION_CODE ORGANIZATION_CODE
682: FROM rcv_transactions_interface rti, rcv_headers_interface rhi ,
683: org_organization_definitions ood,po_releases_all prl,
684: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
685: hr_locations_all_tl hrl, hz_locations hz
686: WHERE rhi.header_interface_id=rti.header_interface_id and
687: rhi.shipment_num= p_shipment_num and
688: pola.po_line_id = rti.po_line_id and
689: nvl(prl.agent_id,ph.agent_id)=v_buyer_id and

Line 717: hr_locations_all_tl hrl,hz_locations hz

713: ood.ORGANIZATION_CODE ORGANIZATION_CODE
714: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh ,
715: org_organization_definitions ood,po_releases_all prl,
716: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
717: hr_locations_all_tl hrl,hz_locations hz
718: WHERE rsh.shipment_header_id=rsl.shipment_header_id and
719: rsh.shipment_num= p_shipment_num and
720: pola.po_line_id = rsl.po_line_id and
721: nvl(prl.agent_id,ph.agent_id)=v_buyer_id and