[Home] [Help]
253: --}
254: AND EXISTS
255: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
256: 'Get a receipt/match for this shipment'
257: FROM rcv_transactions rvt
258: WHERE rvt.po_line_location_id = poll.line_location_id
259: AND rvt.transaction_type IN ('RECEIVE','MATCH')
260: AND rvt.transaction_date <= l_end_date
261: )
328: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
329: AND EXISTS
330: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
331: 'Get a receipt/match for this shipment'
332: FROM rcv_transactions rvt
333: WHERE rvt.po_line_location_id = poll.line_location_id
334: AND rvt.transaction_type IN ('RECEIVE','MATCH')
335: AND rvt.transaction_date <= l_end_date
336: )
409: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
410: AND EXISTS
411: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
412: 'Get a receipt/match for this shipment'
413: FROM rcv_transactions rvt
414: WHERE rvt.po_line_location_id = poll.line_location_id
415: AND rvt.transaction_type IN ('RECEIVE','MATCH')
416: AND rvt.transaction_date <= l_end_date
417: )
493: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
494: AND EXISTS
495: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
496: 'Get a receipt/match for this shipment'
497: FROM rcv_transactions rvt
498: WHERE rvt.po_line_location_id = poll.line_location_id
499: AND rvt.transaction_type IN ('RECEIVE','MATCH')
500: AND rvt.transaction_date <= l_end_date
501: )
574: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
575: AND EXISTS
576: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
577: 'Get a receipt/match for this shipment'
578: FROM rcv_transactions rvt
579: WHERE rvt.po_line_location_id = poll.line_location_id
580: AND rvt.transaction_type IN ('RECEIVE','MATCH')
581: AND rvt.transaction_date <= l_end_date
582: )
661: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
662: AND EXISTS
663: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
664: 'Get a receipt/match for this shipment'
665: FROM rcv_transactions rvt
666: WHERE rvt.po_line_location_id = poll.line_location_id
667: AND rvt.transaction_type IN ('RECEIVE','MATCH')
668: AND rvt.transaction_date <= l_end_date
669: )
1450: currency_code,
1451: NVL(currency_conversion_rate, 1) currency_conversion_rate,
1452: currency_conversion_date,
1453: currency_conversion_type
1454: FROM rcv_transactions
1455: WHERE po_line_location_id = x_accrual_rec.shipment_id
1456: AND ((transaction_type = 'RECEIVE' AND parent_transaction_id = -1)
1457: OR
1458: (transaction_type = 'MATCH'))
2311: DECODE(p_service_flag,
2312: 1, rt.amount,
2313: rt.source_doc_quantity) quantity,
2314: rt.parent_transaction_id
2315: FROM rcv_transactions rt
2316: WHERE rt.transaction_date <= p_end_date
2317: START WITH rt.po_line_location_id = p_line_location_id
2318: AND ((rt.transaction_type = 'RECEIVE' AND rt.parent_transaction_id = -1)
2319: OR
2335: DECODE(p_service_flag,
2336: 1, rt.amount,
2337: rt.source_doc_quantity) quantity,
2338: rt.parent_transaction_id
2339: FROM rcv_transactions rt
2340: WHERE rt.transaction_date <= p_end_date
2341: START WITH rt.shipment_header_id = p_rcv_shipment_id
2342: AND rt.po_line_location_id = p_line_location_id
2343: AND ((rt.transaction_type = 'RECEIVE' AND rt.parent_transaction_id = -1)
2407: -- Get the parent transaction type
2408: l_stmt_num := 20;
2409: SELECT rt.transaction_type
2410: INTO l_parent_type
2411: FROM rcv_transactions rt
2412: WHERE rt.transaction_id = l_shipment_rec.parent_transaction_id;
2413:
2414: END IF;
2415:
2501: -- Get the parent transaction type
2502: l_stmt_num := 50;
2503: SELECT rt.transaction_type
2504: INTO l_parent_type
2505: FROM rcv_transactions rt
2506: WHERE rt.transaction_id = l_txn_rec.parent_transaction_id;
2507:
2508: END IF;
2509: