[Home] [Help]
35: x_quantity_received,
36: x_receiving_unit_of_measure
37: from rcv_transactions rct,
38: rcv_shipment_headers rsh,
39: rcv_shipment_lines rsl
40: where transaction_id = p_last_receipt_transaction_id
41: and rct.shipment_header_id = rsh.shipment_header_id
42: and rct.shipment_line_id = rsl.shipment_line_id ;
43:
41: and rct.shipment_header_id = rsh.shipment_header_id
42: and rct.shipment_line_id = rsl.shipment_line_id ;
43:
44: /* Bug 1706360: Get the last_receipt_quantity (purchasing_quantity)
45: as the sum(quantity_received) from rcv_shipment_lines for the receipt_num
46: corresponding to p_last_receipt_transaction_id.
47: Also added item id cond. to the foll. sql stmt. so that
48: the qty received only against that item is computed. This is because
49: more than one item can be received in the same receipt. */
49: more than one item can be received in the same receipt. */
50:
51: select sum(quantity_received)
52: into x_quantity_received
53: from rcv_shipment_lines rsl
54: where rsl.shipment_header_id=(select rct.shipment_header_id
55: from rcv_transactions rct where
56: transaction_id = p_last_receipt_transaction_id)
57: and rsl.item_id = p_item_id;
659:
660: select max(rct.transaction_id)
661: into x_last_receipt_id
662: from rcv_transactions rct,
663: rcv_shipment_lines rsl,
664: po_headers poh
665: where rct.shipment_line_id = rsl.shipment_line_id
666: and rct.transaction_type = 'RECEIVE'
667: and rct.transaction_date between
675: and poh.supply_agreement_flag = 'Y'
676: and rct.transaction_date in
677: (select max(rct2.transaction_date)
678: from rcv_transactions rct2,
679: rcv_shipment_lines rsl2,
680: po_headers poh2
681: where rct2.shipment_line_id = rsl2.shipment_line_id
682: and rct2.transaction_type = 'RECEIVE'
683: and rct2.transaction_date between