[Home] [Help]
251: --}
252: AND EXISTS
253: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
254: 'Get a receipt/match for this shipment'
255: FROM rcv_transactions rvt
256: WHERE rvt.po_line_location_id = poll.line_location_id
257: AND rvt.transaction_type IN ('RECEIVE','MATCH')
258: AND rvt.transaction_date <= l_end_date
259: );
323: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
324: AND EXISTS
325: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
326: 'Get a receipt/match for this shipment'
327: FROM rcv_transactions rvt
328: WHERE rvt.po_line_location_id = poll.line_location_id
329: AND rvt.transaction_type IN ('RECEIVE','MATCH')
330: AND rvt.transaction_date <= l_end_date
331: );
401: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
402: AND EXISTS
403: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
404: 'Get a receipt/match for this shipment'
405: FROM rcv_transactions rvt
406: WHERE rvt.po_line_location_id = poll.line_location_id
407: AND rvt.transaction_type IN ('RECEIVE','MATCH')
408: AND rvt.transaction_date <= l_end_date
409: );
482: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
483: AND EXISTS
484: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
485: 'Get a receipt/match for this shipment'
486: FROM rcv_transactions rvt
487: WHERE rvt.po_line_location_id = poll.line_location_id
488: AND rvt.transaction_type IN ('RECEIVE','MATCH')
489: AND rvt.transaction_date <= l_end_date
490: );
560: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
561: AND EXISTS
562: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
563: 'Get a receipt/match for this shipment'
564: FROM rcv_transactions rvt
565: WHERE rvt.po_line_location_id = poll.line_location_id
566: AND rvt.transaction_type IN ('RECEIVE','MATCH')
567: AND rvt.transaction_date <= l_end_date
568: );
644: poll.quantity - NVL(poll.quantity_cancelled,0)) > 0
645: AND EXISTS
646: (SELECT /*+ PUSH_SUBQ NO_UNNEST */
647: 'Get a receipt/match for this shipment'
648: FROM rcv_transactions rvt
649: WHERE rvt.po_line_location_id = poll.line_location_id
650: AND rvt.transaction_type IN ('RECEIVE','MATCH')
651: AND rvt.transaction_date <= l_end_date
652: );
1431: currency_code,
1432: NVL(currency_conversion_rate, 1) currency_conversion_rate,
1433: currency_conversion_date,
1434: currency_conversion_type
1435: FROM rcv_transactions
1436: WHERE po_line_location_id = x_accrual_rec.shipment_id
1437: AND ((transaction_type = 'RECEIVE' AND parent_transaction_id = -1)
1438: OR
1439: (transaction_type = 'MATCH'))
2206: DECODE(p_service_flag,
2207: 1, rt.amount,
2208: rt.source_doc_quantity) quantity,
2209: rt.parent_transaction_id
2210: FROM rcv_transactions rt
2211: WHERE rt.transaction_date <= p_end_date
2212: START WITH rt.po_line_location_id = p_line_location_id
2213: AND ((rt.transaction_type = 'RECEIVE' AND rt.parent_transaction_id = -1)
2214: OR
2228: DECODE(p_service_flag,
2229: 1, rt.amount,
2230: rt.source_doc_quantity) quantity,
2231: rt.parent_transaction_id
2232: FROM rcv_transactions rt
2233: WHERE rt.transaction_date <= p_end_date
2234: START WITH rt.shipment_header_id = p_rcv_shipment_id
2235: AND rt.po_line_location_id = p_line_location_id
2236: AND ((rt.transaction_type = 'RECEIVE' AND rt.parent_transaction_id = -1)
2297: -- Get the parent transaction type
2298: l_stmt_num := 20;
2299: SELECT rt.transaction_type
2300: INTO l_parent_type
2301: FROM rcv_transactions rt
2302: WHERE rt.transaction_id = l_shipment_rec.parent_transaction_id;
2303:
2304: END IF;
2305:
2391: -- Get the parent transaction type
2392: l_stmt_num := 50;
2393: SELECT rt.transaction_type
2394: INTO l_parent_type
2395: FROM rcv_transactions rt
2396: WHERE rt.transaction_id = l_txn_rec.parent_transaction_id;
2397:
2398: END IF;
2399: