[Home] [Help]
19: select max(rct.transaction_id)
20: into x_last_receipt_id
21: from rcv_transactions rct,
22: rcv_shipment_lines rsl,
23: po_headers poh
24: where rct.shipment_line_id = rsl.shipment_line_id
25: and rct.transaction_type = 'RECEIVE'
26: and rct.transaction_date between
27: to_date(p_cum_period_start_date) and
35: and rct.transaction_date in
36: (select max(rct2.transaction_date)
37: from rcv_transactions rct2,
38: rcv_shipment_lines rsl2,
39: po_headers poh2
40: where rct2.shipment_line_id = rsl2.shipment_line_id
41: and rct2.transaction_type = 'RECEIVE'
42: and rct2.transaction_date between
43: to_date(p_cum_period_start_date) and
80: select max(rct.transaction_id)
81: into x_last_receipt_id
82: from rcv_transactions rct,
83: rcv_shipment_lines rsl,
84: po_headers poh
85: where rct.shipment_line_id = rsl.shipment_line_id
86: and rct.transaction_type = 'RECEIVE'
87: and rct.transaction_date between
88: to_date(p_cum_period_start_date) and
96: and rct.transaction_date in
97: (select max(rct2.transaction_date)
98: from rcv_transactions rct2,
99: rcv_shipment_lines rsl2,
100: po_headers poh2
101: where rct2.shipment_line_id = rsl2.shipment_line_id
102: and rct2.transaction_type = 'RECEIVE'
103: and rct2.transaction_date between
104: to_date(p_cum_period_start_date) and
145: select max(rct.transaction_id)
146: into x_last_receipt_id
147: from rcv_transactions rct,
148: rcv_shipment_lines rsl,
149: po_headers poh
150: where rct.shipment_line_id = rsl.shipment_line_id
151: and rct.transaction_type = 'RECEIVE'
152: and rct.transaction_date between
153: to_date(p_cum_period_start_date) and
161: and rct.transaction_date in
162: (select max(rct2.transaction_date)
163: from rcv_transactions rct2,
164: rcv_shipment_lines rsl2,
165: po_headers poh2
166: where rct2.shipment_line_id = rsl2.shipment_line_id
167: and rct2.transaction_type = 'RECEIVE'
168: and rct2.transaction_date between
169: to_date(p_cum_period_start_date) and
263: rsl.unit_of_measure,
264: rsl.primary_unit_of_measure,
265: rct.transaction_id
266: FROM rcv_shipment_lines rsl,
267: po_headers poh,
268: po_lines pol,
269: rcv_transactions rct
270: WHERE rct.shipment_line_id = rsl.shipment_line_id
271: AND rct.transaction_type = 'RECEIVE'
293: SELECT rsl.quantity_received,
294: rsl.unit_of_measure,
295: rsl.primary_unit_of_measure
296: FROM rcv_shipment_lines rsl,
297: po_headers poh,
298: po_lines pol
299: WHERE pol.item_id = X_item_id
300: AND rsl.po_line_id = pol.po_line_id
301: AND pol.po_header_id = poh.po_header_id