APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_LINES

Line 187: jai_rcv_lines jrl

183: cursor c_pending_tp_receipts(cp_org_id number) is /* modified the cursor query for bug 8567640 */
184: SELECT
185: /*+ no_expand */ jrt.shipment_header_id
186: FROM jai_rcv_transactions jrt,
187: jai_rcv_lines jrl
188: WHERE(jrt.transaction_type = 'RECEIVE' OR(jrt.transaction_type = 'CORRECT'
189: AND jrt.parent_transaction_type = 'RECEIVE'))
190: AND jrt.third_party_flag = 'N'
191: AND jrt.shipment_header_id = jrl.shipment_header_id

Line 333: from JAI_RCV_LINES jrl

329: and third_party_flag = 'N'
330: and exists
331: (
332: select '1'
333: from JAI_RCV_LINES jrl
334: where jrt.shipment_header_id = jrl.shipment_header_id
335: and jrt.shipment_line_id = jrl.shipment_line_id
336: and jrl.tax_modified_flag <> 'Y'
337: );