APPS.CHV_CUM_PERIODS_S1 dependencies on RCV_TRANSACTIONS

Line 86: rcv_transactions rct

82: rct.transaction_id
83: FROM rcv_shipment_lines rsl,
84: po_headers poh,
85: po_lines pol,
86: rcv_transactions rct
87: WHERE rct.shipment_line_id = rsl.shipment_line_id
88: AND rct.transaction_type = 'RECEIVE'
89: AND rsl.po_header_id = poh.po_header_id
90: AND rsl.po_line_id = pol.po_line_id

Line 128: FROM rcv_transactions rct

124: -- the receipt transaction
125: CURSOR C2 IS
126: SELECT rct.primary_quantity,
127: rct.transaction_id
128: FROM rcv_transactions rct
129: WHERE rct.transaction_type = 'RETURN TO VENDOR'
130: AND rct.parent_transaction_id = X_transaction_id;
131:
132: /* Bug 2251090 fixed. In the where clause of the below sql, added

Line 156: from rcv_transactions rct

152: AND rsl.to_organization_id = X_organization_id
153: AND poh.supply_agreement_flag = 'Y'
154: AND exists
155: (select 1
156: from rcv_transactions rct
157: where rct.transaction_date between x_cum_period_start
158: and nvl(x_cum_period_end,
159: rct.transaction_date+1)
160: and rct.shipment_line_id = rsl.shipment_line_id

Line 395: -- We CANNOT just get the primary quantity from rcv_transactions

391: --dbms_output.put_line('Get CUM Qty: TRANSACTION_ID'||X_transaction_id);
392:
393: -- Get the uom code since we only have the unit of measure.
394: -- We need to the uom code to execute uom_convert.
395: -- We CANNOT just get the primary quantity from rcv_transactions
396: -- since it will not have the corrections to that quantity.
397: -- The rcv_shipment line includes the quantity received +
398: -- all corrects to that quantity.
399: X_progress := '090';

Line 468: FROM rcv_transactions rct

464: X_progress := '150';
465:
466: SELECT sum(rct.primary_quantity)
467: INTO X_corrtv_primary_quantity
468: FROM rcv_transactions rct
469: WHERE rct.transaction_type = 'CORRECT'
470: AND rct.parent_transaction_id = X_rtv_transaction_id;
471:
472: EXCEPTION