APPS.JAI_RCV_RT_TRIGGER_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 77: from PO_REQUISITION_LINES_ALL

73:
74: /*Start Additions for Bug 14176672 by mmurtuza*/
75: cursor get_req_deliver_loc(p_organization_id number, p_requisition_line_id number) is
76: select deliver_to_location_id
77: from PO_REQUISITION_LINES_ALL
78: where requisition_line_id = p_requisition_line_id
79: and destination_organization_id = p_organization_id;
80:
81: lv_location_id number;

Line 133: Fix: Added cursor to pick deliver_to_location_id from PO_REQUISITION_LINES_ALL if location_id is null in rcv_transactions

129: check is required for org location set up.
130:
131: 10. 29-Jun-2012 mmurtuza for bug 14176672
132: Description: +:R12.1:INTERNAL ORDER STRUCK IN SHIPPED STATUS
133: Fix: Added cursor to pick deliver_to_location_id from PO_REQUISITION_LINES_ALL if location_id is null in rcv_transactions
134: and passed the same to cursor chk_org_setup_is_present when checking localization setup.
135:
136: 11. 13-Aug-2012 Bug 14010660
137: Description: Excise Invoice Number and Date provided in ASN is not reflected in Receipts