APPS.POS_VIEW_RECEIPTS_GRP dependencies on RCV_TRANSACTIONS

Line 61: rcv_transactions

57: shipment_line_id,
58: po_line_location_id,
59: parent_transaction_id
60: FROM
61: rcv_transactions
62: START WITH transaction_id = c_transaction_id
63: CONNECT BY parent_transaction_id = PRIOR transaction_id;
64:
65: BEGIN

Line 105: FROM rcv_transactions

101: X_po_uom := v_po_uom;
102: ELSIF v_transaction_type = 'RETURN TO VENDOR' THEN
103:
104: SELECT transaction_type INTO v_parent_type
105: FROM rcv_transactions
106: WHERE transaction_id = v_parent_id;
107:
108: if v_parent_type = 'ACCEPT' THEN
109: X_accepted_quantity := X_accepted_quantity - v_primary_quantity;

Line 123: FROM rcv_transactions

119:
120: ELSIF v_transaction_type = 'ACCEPT' THEN
121:
122: SELECT transaction_type INTO v_parent_type
123: FROM rcv_transactions
124: WHERE transaction_id = v_parent_id;
125:
126: if v_parent_type <> 'ACCEPT' THEN
127: X_accepted_quantity := X_accepted_quantity + v_primary_quantity;

Line 137: FROM rcv_transactions

133:
134: ELSIF v_transaction_type = 'REJECT' THEN
135:
136: SELECT transaction_type INTO v_parent_type
137: FROM rcv_transactions
138: WHERE transaction_id = v_parent_id;
139:
140: if v_parent_type <> 'REJECT' then
141: X_rejected_quantity := X_rejected_quantity + v_primary_quantity;

Line 156: FROM rcv_transactions

152: /* The correction function is based on parent transaction type */
153:
154: SELECT transaction_type,parent_transaction_id
155: INTO v_parent_type,grand_parent_id
156: FROM rcv_transactions
157: WHERE transaction_id = v_parent_id;
158:
159: BEGIN
160: SELECT transaction_type INTO grand_parent_type

Line 161: FROM rcv_transactions

157: WHERE transaction_id = v_parent_id;
158:
159: BEGIN
160: SELECT transaction_type INTO grand_parent_type
161: FROM rcv_transactions
162: WHERE transaction_id = grand_parent_id;
163: EXCEPTION
164: WHEN NO_DATA_FOUND THEN
165: NULL;

Line 257: FROM rcv_transactions rt

253:
254:
255: /* Find if lpn exists for the given shipment_line_id */
256: SELECT lpn_id into isLPN
257: FROM rcv_transactions rt
258: WHERE shipment_line_id = p_rcv_shipment_line_id
259: AND transaction_type = 'RECEIVE';
260:
261: IF (isLPN is not null) THEN

Line 353: FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt

349:
350: -- Declare cursor to retrieve the Invoice number for Supplier View.
351: CURSOR inv_cursor(l_shipment_header_id number) IS
352: SELECT DISTINCT ap.invoice_num,ap.invoice_id
353: FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt
354: WHERE ap.invoice_id = al.invoice_id
355: AND al.rcv_transaction_id = rt.transaction_id
356: AND rt.shipment_header_id = l_shipment_header_id;
357:

Line 398: FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt

394:
395: -- Declare cursor to retrieve the Invoice number for Supplier View.
396: CURSOR inv_cursor(l_shipment_line_id number) IS
397: SELECT DISTINCT ap.invoice_num,ap.invoice_id
398: FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt
399: WHERE ap.invoice_id = al.invoice_id
400: AND al.rcv_transaction_id = rt.transaction_id
401: AND rt.shipment_line_id = l_shipment_line_id;
402: