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 1029: PO_LINE_LOCATIONS_ALL POLL

1025: FROM MTL_SYSTEM_ITEMS MSI,
1026: PO_LINES_ALL POL,
1027: PO_DISTRIBUTIONS_ALL POD,
1028: PO_HEADERS_ALL POH,
1029: PO_LINE_LOCATIONS_ALL POLL
1030: WHERE
1031: NVL(POLL.APPROVED_FLAG,'N') = 'Y' AND
1032: NVL(POLL.CANCEL_FLAG, 'N') = 'N' AND
1033: NVL(POLL.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING', 'CANCELLED') AND

Line 1968: from rcv_transactions rcv,po_line_locations_all poll,

1964: select distinct nvl(pod.wf_item_key, rcv.po_header_id ||';'||
1965: rcv.deliver_to_person_id || ';' ||
1966: to_char(nvl(poll.promised_date,
1967: poll.need_by_date), 'DD-MON-YYYY'))
1968: from rcv_transactions rcv,po_line_locations_all poll,
1969: po_distributions_all pod
1970: where group_id = x_group_id and
1971: poll.line_location_id = rcv.po_line_location_id AND
1972: pod.po_distribution_id = rcv.po_distribution_id;