APPS.PO_CHARGES_GRP dependencies on RCV_SHIPMENT_LINES

Line 104: rcv_shipment_lines rsl

100: ap_invoice_lines_all ail_charge_lines,
101: ap_invoices_all ai_non_fte_invoices,
102: po_distributions_all pod,
103: po_line_locations_all poll,
104: rcv_shipment_lines rsl
105: WHERE aid_charge.charge_applicable_to_dist_id = aid_matched_items.invoice_distribution_id
106: AND NVL(aid_charge.rcv_charge_addition_flag, 'N') = 'N'
107: --AND nvl(aid_charge.posted_flag, 'N') = 'Y'
108: AND aid_matched_items.po_distribution_id is not null

Line 124: FROM rcv_shipment_lines rsl2

120: poll.amount_received >= poll.amount
121: )
122: -- latest receipt for this PO
123: AND rsl.shipment_line_id = ( SELECT MAX(rsl2.shipment_line_id)
124: FROM rcv_shipment_lines rsl2
125: WHERE rsl2.po_line_location_id = poll.line_location_id );
126:
127: cursor ap_rcv_charge_distr_csr is
128: SELECT decode(ail_charge_lines.line_type_lookup_code, 'MISCELLANEOUS', 'ORACLE_AP_MISC',

Line 144: rcv_shipment_lines rsl

140: FROM ap_invoice_distributions_all aid_charge,
141: ap_invoice_lines_all ail_charge_lines,
142: ap_invoices_all ai_non_fte_invoices,
143: rcv_transactions rt,
144: rcv_shipment_lines rsl
145: WHERE aid_charge.rcv_transaction_id is NOT NULL
146: AND NVL(aid_charge.rcv_charge_addition_flag, 'N') = 'N'
147: --AND nvl(aid_charge.posted_flag, 'N') = 'Y'
148: AND aid_charge.invoice_id = ail_charge_lines.invoice_id