DBA Data[Home] [Help]

APPS.POS_ASN_NOTIF dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 631: ship_to_org org_organization_definitions.ORGANIZATION_CODE%type

627: ship_qty rcv_transactions_interface.quantity%TYPE,
628: --rcvd_qty po_line_locations_all.quantity_received%type,
629: rcvd_qty NUMBER,
630: ship_to rcv_transactions_interface.ship_to_location_code%type,
631: ship_to_org org_organization_definitions.ORGANIZATION_CODE%type
632: );
633:
634: NL VARCHAR2(1) := fnd_global.newline;
635: l_document VARCHAR2(32000) := '';

Line 683: org_organization_definitions ood,po_releases_all prl,

679: NVL( HRL.LOCATION_CODE,
680: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
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

Line 715: org_organization_definitions ood,po_releases_all prl,

711: NVL( HRL.LOCATION_CODE,
712: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
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