APPS.POR_RCV_ORD_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 105: from po_line_locations_all poll

101:
102: begin
103: select org_id
104: into x_txn_org_id
105: from po_line_locations_all poll
106: where line_location_id = l_lineLocationId;
107:
108: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
109: mo_global.set_policy_context(p_access_mode => 'S',

Line 877: l_country_of_origin PO_LINE_LOCATIONS_ALL.COUNTRY_OF_ORIGIN_CODE%TYPE;

873: l_req_distribution_id NUMBER:= NULL;
874: X_MATCHING_BASIS PO_LINES_ALL.MATCHING_BASIS%TYPE;
875: X_JOB_ID PO_LINES_ALL.JOB_ID%TYPE;
876: --Bug 8893932 PO RECEIVED FROM IPROCUREMENT DOESNT POPULATE COUNTRY OF ORIGIN
877: l_country_of_origin PO_LINE_LOCATIONS_ALL.COUNTRY_OF_ORIGIN_CODE%TYPE;
878: -- l_receipt_num varchar2(100);
879: -- l_asn_exist varchar2(8); -- probably to be renamed as sourceTypeFlag
880: -- l_receipt_source_code varchar2(100) := 'VENDOR';
881: -- x_shipment_line_id number :=0; -- to delete

Line 1034: PO_LINE_LOCATIONS_ALL POLL

1030: FROM MTL_SYSTEM_ITEMS MSI,
1031: PO_LINES_ALL POL,
1032: PO_DISTRIBUTIONS_ALL POD,
1033: PO_HEADERS_ALL POH,
1034: PO_LINE_LOCATIONS_ALL POLL
1035: WHERE
1036: NVL(POLL.APPROVED_FLAG,'N') = 'Y' AND
1037: NVL(POLL.CANCEL_FLAG, 'N') = 'N' AND
1038: NVL(POLL.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING', 'CANCELLED') AND

Line 1978: from rcv_transactions rcv,po_line_locations_all poll,

1974: procedure cancel_pending_notifs (x_group_id IN NUMBER) is
1975:
1976: cursor C1 is
1977: select distinct nvl(pod.wf_item_key,wf.ITEM_KEY)
1978: from rcv_transactions rcv,po_line_locations_all poll,
1979: po_distributions_all pod,wf_items wf
1980: where group_id = x_group_id and
1981: poll.line_location_id = rcv.po_line_location_id AND
1982: pod.po_distribution_id = rcv.po_distribution_id