eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPPACQ dependencies on RCV_TRANSACTIONS

Line 56: rcv_transactions rt,

52: (SELECT
53: distinct rt.transaction_id ,
54: nvl(poll.lcm_flag,'N') lcm_flag
55: FROM
56: rcv_transactions rt,
57: po_line_locations_all poll, -- Added for Complex work Procurement
58: cst_cost_group_assignments ccga1
59: WHERE rt.transaction_date BETWEEN i_start_date and i_end_date AND
60: -- Added for Complex work Procurement

Line 115: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment

111: from ap_invoice_distributions_all aida
112: where aida.invoice_id = i_invoice_no
113: and aida.rcv_transaction_id IS NOT NULL
114: and aida.line_type_lookup_code = 'ITEM'
115: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
116: WHERE rt.transaction_id = aida.rcv_transaction_id
117: AND rae.rcv_transaction_id = rt.transaction_id
118: AND rae.event_type_id = 1 -- RECEIVE
119: AND rae.trx_flow_header_id is not NULL)

Line 121: FROM rcv_transactions rt,

117: AND rae.rcv_transaction_id = rt.transaction_id
118: AND rae.event_type_id = 1 -- RECEIVE
119: AND rae.trx_flow_header_id is not NULL)
120: AND NOT EXISTS ( SELECT 1
121: FROM rcv_transactions rt,
122: po_distributions_all pod
123: WHERE rt.transaction_id = aida.rcv_transaction_id
124: AND pod.line_location_id = rt.po_line_location_id
125: AND pod.destination_type_code = 'EXPENSE' )

Line 127: from rcv_transactions rt2

123: WHERE rt.transaction_id = aida.rcv_transaction_id
124: AND pod.line_location_id = rt.po_line_location_id
125: AND pod.destination_type_code = 'EXPENSE' )
126: AND EXISTS (Select 1
127: from rcv_transactions rt2
128: where rt2.transaction_type in ('DELIVER')
129: START WITH rt2.transaction_id = aida.rcv_transaction_id
130: CONNECT BY
131: prior rt2.transaction_id = rt2.parent_transaction_id

Line 142: from rcv_transactions

138: -- ----------------------------------------------------------------------------
139: CURSOR c_receipts_src_flag_2_rcptid(i_receipt_no IN NUMBER) IS
140: /*bug 5044215/5264793.Only pick up receipts that have delivers */
141: Select transaction_id
142: from rcv_transactions
143: where transaction_type in ('DELIVER')
144: START WITH transaction_id = i_receipt_no
145: CONNECT BY
146: prior transaction_id = parent_transaction_id;

Line 165: AND EXISTS (select 1 from rcv_transactions rt,

161: AND aida2.posted_flag = 'Y'
162: AND aida2.org_id = aida.org_id /* rgangara perf bug 7475729 */
163: AND aida2.line_type_lookup_code <> 'REC_TAX'
164: AND aida.rcv_transaction_id is not null
165: AND EXISTS (select 1 from rcv_transactions rt,
166: po_line_locations_all poll, -- Added for Complex work Procurement
167: cst_cost_group_assignments ccga
168: where rt.transaction_id = aida.rcv_transaction_id
169: -- Added for Complex work Procurement

Line 185: FROM RCV_TRANSACTIONS RT,

181: OR
182: ( rt.transaction_type = 'MATCH'))
183: )
184: AND NOT EXISTS ( SELECT 1
185: FROM RCV_TRANSACTIONS RT,
186: PO_DISTRIBUTIONS_ALL POD
187: WHERE RT.TRANSACTION_ID = AIDA.RCV_TRANSACTION_ID
188: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
189: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE'

Line 193: from rcv_transactions rt2

189: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE'
190: )
191: /*bug 5044215/5264793.Only pick up receipts that have delivers */
192: AND EXISTS (Select 1
193: from rcv_transactions rt2
194: where rt2.transaction_type in ('DELIVER')
195: START WITH rt2.transaction_id = aida.rcv_transaction_id
196: CONNECT BY
197: prior rt2.transaction_id = rt2.parent_transaction_id

Line 202: AND NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment

198: )
199: /* Invoice Lines Project
200: Removing reference to ap_chrg_allocations_all
201: */
202: AND NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
203: WHERE rt.transaction_id = aida.rcv_transaction_id
204: AND rae.rcv_transaction_id = rt.transaction_id
205: AND rae.event_type_id = 1 -- RECEIVE
206: AND rae.trx_flow_header_id is not NULL)

Line 214: and exists (select 1 from rcv_transactions rt,

210: and aida.posted_flag = 'Y'
211: /* Invoice Lines Project, TAX is now REC_TAX and NONREC_TAX */
212: and aida.line_type_lookup_code <> 'REC_TAX'
213: and aida.rcv_transaction_id is NOT NULL
214: and exists (select 1 from rcv_transactions rt,
215: po_line_locations_all poll, -- Added for Complex work Procurement
216: cst_cost_group_assignments ccga
217: where rt.transaction_id = aida.rcv_transaction_id
218: -- Added for Complex work Procurement

Line 234: FROM RCV_TRANSACTIONS RT,

230: OR
231: ( rt.transaction_type = 'MATCH'))
232: )
233: AND NOT EXISTS ( SELECT 1
234: FROM RCV_TRANSACTIONS RT,
235: PO_DISTRIBUTIONS_ALL POD
236: WHERE RT.TRANSACTION_ID = AIDA.RCV_TRANSACTION_ID
237: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
238: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE' )

Line 241: from rcv_transactions rt2

237: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
238: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE' )
239: /*bug 5044215/5264793.Only pick up receipts that have delivers */
240: AND EXISTS (Select 1
241: from rcv_transactions rt2
242: where rt2.transaction_type in ('DELIVER')
243: START WITH rt2.transaction_id = aida.rcv_transaction_id
244: CONNECT BY
245: prior rt2.transaction_id = rt2.parent_transaction_id

Line 247: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment

243: START WITH rt2.transaction_id = aida.rcv_transaction_id
244: CONNECT BY
245: prior rt2.transaction_id = rt2.parent_transaction_id
246: )
247: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
248: WHERE rt.transaction_id = aida.rcv_transaction_id
249: AND rae.rcv_transaction_id = rt.transaction_id
250: AND rae.event_type_id = 1 -- RECEIVE
251: AND rae.trx_flow_header_id is not NULL);

Line 279: rcv_transactions rt,

275: max(clat.transaction_id) transaction_id
276: FROM cst_lc_adj_transactions clat,
277: cst_cost_group_assignments ccga1,
278: mtl_parameters mp,
279: rcv_transactions rt,
280: rcv_parameters rp,
281: mtl_system_items msi,
282: po_line_locations_all poll,
283: mtl_units_of_measure muom

Line 328: FROM rcv_transactions

324: sum(mmt.primary_quantity) primary_quantity
325: FROM ( SELECT po_distribution_id,
326: transaction_id,
327: organization_id
328: FROM rcv_transactions
329: WHERE transaction_type IN ('DELIVER','RETURN TO RECEIVING','CORRECT')
330: AND transaction_date < p_valuation_date
331: AND organization_id = p_organization_id
332: START WITH transaction_id = p_rcv_transaction_id

Line 552: l_nqr rcv_transactions.quantity%TYPE := 0;

548: l_recs_processed := l_recs_processed + 1;
549: IF (c_rec.lcm_flag <> 'Y') THEN
550: DECLARE
551: l_rec_ct NUMBER := 0;
552: l_nqr rcv_transactions.quantity%TYPE := 0;
553: l_inv_count number;
554: l_header cst_rcv_acq_costs.header_id%TYPE;
555: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
556: l_po_uom mtl_units_of_measure.uom_code%TYPE;

Line 559: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;

555: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
556: l_po_uom mtl_units_of_measure.uom_code%TYPE;
557: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
558: l_po_price po_lines_all.unit_price%TYPE;
559: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
560: l_po_line_loc po_lines_all.po_line_id%TYPE;
561: l_item_id mtl_system_items.inventory_item_id%TYPE;
562: l_org_id rcv_transactions.organization_id%TYPE;
563: l_poll_quantity po_line_locations_all.quantity%TYPE;

Line 562: l_org_id rcv_transactions.organization_id%TYPE;

558: l_po_price po_lines_all.unit_price%TYPE;
559: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
560: l_po_line_loc po_lines_all.po_line_id%TYPE;
561: l_item_id mtl_system_items.inventory_item_id%TYPE;
562: l_org_id rcv_transactions.organization_id%TYPE;
563: l_poll_quantity po_line_locations_all.quantity%TYPE;
564: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
565: l_po_count NUMBER; -- remove this later
566: l_nr_tax_rate NUMBER;

Line 568: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;

564: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
565: l_po_count NUMBER; -- remove this later
566: l_nr_tax_rate NUMBER;
567: l_match_option po_line_locations_all.match_option%TYPE;
568: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
569: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
570:
571: BEGIN
572: If G_DEBUG ='Y' then

Line 663: rcv_transactions rt7

659:
660: SELECT nvl(poll.match_option,'P')
661: INTO l_match_option
662: FROM po_line_locations_all poll,
663: rcv_transactions rt7
664: WHERE
665: poll.line_location_id = rt7.po_line_location_id
666: AND rt7.transaction_id = c_rec.transaction_id;
667:

Line 678: FROM rcv_transactions rt2,

674: l_stmt_num := 140;
675:
676: SELECT count(rt2.transaction_id)
677: INTO l_po_count
678: FROM rcv_transactions rt2,
679: po_lines_all pol1,
680: po_line_locations_all poll1
681: WHERE rt2.transaction_id = c_rec.transaction_id
682: AND rt2.po_line_location_id = poll1.line_location_id

Line 708: rcv_transactions rt3,

704: l_poll_quantity,
705: l_org_id,
706: l_order_type_lookup_code
707: FROM
708: rcv_transactions rt3,
709: rcv_shipment_lines rsl,
710: po_line_locations_all poll2
711: WHERE
712: rt3.transaction_id = c_rec.transaction_id

Line 760: rcv_transactions rt33

756: l_order_type_lookup_code
757: FROM
758: po_lines_all pol2,
759: po_line_locations_all poll3,
760: rcv_transactions rt33
761: WHERE
762: rt33.transaction_id = c_rec.transaction_id
763: AND rt33.po_line_location_id = poll3.line_location_id
764: AND pol2.po_line_id = poll3.po_line_id;

Line 951: RCV_TRANSACTIONS RT,

947: nvl(ad2.base_amount, nvl(ad2.amount, 0)) base_amount
948: FROM
949: ap_invoice_distributions_all ad2,
950: -- J Changes -----------------------------------------------------------
951: RCV_TRANSACTIONS RT,
952: PO_LINES_ALL POL,
953: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
954: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
955: ------------------------------------------------------------------------

Line 1208: l_net_qty_rec rcv_transactions.quantity%TYPE := 0;

1204: l_rct_landed_cost NUMBER;
1205: l_rec_ct NUMBER;
1206: l_rct_adj_landed_cost NUMBER;
1207: l_lcm_acq_cost NUMBER;
1208: l_net_qty_rec rcv_transactions.quantity%TYPE := 0;
1209: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1210: l_nr_tax_rate NUMBER;
1211: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1212: l_po_uom mtl_units_of_measure.uom_code%TYPE;

Line 1215: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;

1211: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1212: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1213: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1214: l_po_price po_lines_all.unit_price%TYPE;
1215: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1216: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1217: l_item_id mtl_system_items.inventory_item_id%TYPE;
1218: l_org_id rcv_transactions.organization_id%TYPE;
1219: BEGIN

Line 1218: l_org_id rcv_transactions.organization_id%TYPE;

1214: l_po_price po_lines_all.unit_price%TYPE;
1215: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1216: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1217: l_item_id mtl_system_items.inventory_item_id%TYPE;
1218: l_org_id rcv_transactions.organization_id%TYPE;
1219: BEGIN
1220: l_stmt_num := 1000;
1221: SELECT count(rcv_transaction_id)
1222: INTO l_rec_ct

Line 1235: FROM rcv_transactions

1231: IF l_rec_ct = 0 THEN /*Hook has not been used*/
1232: l_stmt_num := 1010;
1233: SELECT unit_landed_cost
1234: INTO l_rct_landed_cost
1235: FROM rcv_transactions
1236: WHERE transaction_id = c_rec.transaction_id;
1237: l_stmt_num := 1020;
1238:
1239: SELECT nvl(Max(new_landed_cost),-1)

Line 1305: rcv_transactions rt33

1301: l_rate
1302: FROM
1303: po_lines_all pol2,
1304: po_line_locations_all poll3,
1305: rcv_transactions rt33
1306: WHERE rt33.transaction_id = c_rec.transaction_id
1307: AND rt33.po_line_location_id = poll3.line_location_id
1308: AND pol2.po_line_id = poll3.po_line_id;
1309:

Line 2345: l_nqr rcv_transactions.quantity%TYPE := 0;

2341:
2342: l_recs_processed := l_recs_processed + 1;
2343: DECLARE
2344: l_rec_ct NUMBER := 0;
2345: l_nqr rcv_transactions.quantity%TYPE := 0;
2346: l_inv_count number;
2347: l_header cst_rcv_acq_costs.header_id%TYPE;
2348: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2349: l_po_uom mtl_units_of_measure.uom_code%TYPE;

Line 2352: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;

2348: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2349: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2350: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2351: l_po_price po_lines_all.unit_price%TYPE;
2352: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2353: l_po_line_loc po_lines_all.po_line_id%TYPE;
2354: l_item_id mtl_system_items.inventory_item_id%TYPE;
2355: l_org_id rcv_transactions.organization_id%TYPE;
2356: l_poll_quantity po_line_locations_all.quantity%TYPE;

Line 2355: l_org_id rcv_transactions.organization_id%TYPE;

2351: l_po_price po_lines_all.unit_price%TYPE;
2352: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2353: l_po_line_loc po_lines_all.po_line_id%TYPE;
2354: l_item_id mtl_system_items.inventory_item_id%TYPE;
2355: l_org_id rcv_transactions.organization_id%TYPE;
2356: l_poll_quantity po_line_locations_all.quantity%TYPE;
2357: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
2358: l_po_count NUMBER; -- remove this later
2359: l_nr_tax_rate NUMBER;

Line 2361: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;

2357: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
2358: l_po_count NUMBER; -- remove this later
2359: l_nr_tax_rate NUMBER;
2360: l_match_option po_line_locations_all.match_option%TYPE;
2361: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
2362: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
2363:
2364: BEGIN
2365: If G_DEBUG ='Y' then

Line 2501: rcv_transactions rt7

2497:
2498: SELECT nvl(poll.match_option,'P')
2499: INTO l_match_option
2500: FROM po_line_locations_all poll,
2501: rcv_transactions rt7
2502: WHERE
2503: poll.line_location_id = rt7.po_line_location_id
2504: AND rt7.transaction_id = l_rec_transaction_id;
2505:

Line 2516: FROM rcv_transactions rt2,

2512: l_stmt_num := 141;
2513:
2514: SELECT count(rt2.transaction_id)
2515: INTO l_po_count
2516: FROM rcv_transactions rt2,
2517: po_lines_all pol1,
2518: po_line_locations_all poll1
2519: WHERE rt2.transaction_id = l_rec_transaction_id
2520: AND rt2.po_line_location_id = poll1.line_location_id

Line 2546: rcv_transactions rt3,

2542: l_poll_quantity,
2543: l_org_id,
2544: l_order_type_lookup_code
2545: FROM
2546: rcv_transactions rt3,
2547: rcv_shipment_lines rsl,
2548: po_line_locations_all poll2
2549: WHERE
2550: rt3.transaction_id = l_rec_transaction_id

Line 2598: rcv_transactions rt33

2594: l_order_type_lookup_code
2595: FROM
2596: po_lines_all pol2,
2597: po_line_locations_all poll3,
2598: rcv_transactions rt33
2599: WHERE
2600: rt33.transaction_id = l_rec_transaction_id
2601: AND rt33.po_line_location_id = poll3.line_location_id
2602: AND pol2.po_line_id = poll3.po_line_id;

Line 2785: RCV_TRANSACTIONS RT,

2781: nvl(ad2.base_amount, nvl(ad2.amount, 0)) base_amount
2782: FROM
2783: ap_invoice_distributions_all ad2,
2784: -- J Changes -----------------------------------------------------------
2785: RCV_TRANSACTIONS RT,
2786: PO_LINES_ALL POL,
2787: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
2788: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
2789: ------------------------------------------------------------------------

Line 3182: FROM RCV_TRANSACTIONS RT

3178: SELECT RT.TRANSACTION_ID,
3179: RT.TRANSACTION_TYPE,
3180: RT.AMOUNT,
3181: RT.PARENT_TRANSACTION_ID
3182: FROM RCV_TRANSACTIONS RT
3183: WHERE ( ( (i_source_flag = 1)
3184: AND ( ( (i_res_flag =1)
3185: AND (rt.transaction_date between i_start_date and i_end_date))
3186: OR (i_res_flag = 2)))

Line 3201: rcv_transactions rt4

3197: rt4.primary_quantity,
3198: rt4.quantity,/* ADDED FOR #BUG6697382*/
3199: rt4.parent_transaction_id
3200: FROM
3201: rcv_transactions rt4
3202: WHERE
3203: (((i_source_flag = 1) AND (((i_res_flag =1) AND (rt4.transaction_date between i_start_date and i_end_date)) OR (i_res_flag = 2))) OR ((i_source_flag = 2 ) AND (rt4.transaction_date <= i_end_date)))
3204: START WITH
3205: rt4.transaction_id = i_transaction_id

Line 3212: l_parent_type rcv_transactions.transaction_type%TYPE;

3208:
3209: l_nqr NUMBER := 0;
3210: l_actual_nqr NUMBER:=0;/* ADDED FOR #BUG6679382*/
3211: l_po_line_type_code VARCHAR2(25);
3212: l_parent_type rcv_transactions.transaction_type%TYPE;
3213: l_stmt_num NUMBER := 0;
3214: BEGIN
3215:
3216: ---------------------------------------------------------

Line 3235: RCV_TRANSACTIONS RT

3231: SELECT NVL(POLL.MATCHING_BASIS, POL.MATCHING_BASIS) -- Changed for Complex work Procurement
3232: INTO L_PO_LINE_TYPE_CODE
3233: FROM PO_LINES_ALL POL,
3234: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
3235: RCV_TRANSACTIONS RT
3236: WHERE POL.PO_LINE_ID = RT.PO_LINE_ID
3237: AND POLL.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID-- Added for Complex work Procurement
3238: AND RT.TRANSACTION_ID = I_TRANSACTION_ID;
3239:

Line 3249: FROM rcv_transactions

3245: l_stmt_num := 20;
3246:
3247: SELECT transaction_type
3248: INTO l_parent_type
3249: FROM rcv_transactions
3250: WHERE transaction_id = c_amount_rec.parent_transaction_id;
3251: END IF;
3252:
3253: IF c_amount_rec.transaction_id = i_transaction_id THEN

Line 3285: rcv_transactions rt5

3281: rt5.transaction_type
3282: INTO
3283: l_parent_type
3284: FROM
3285: rcv_transactions rt5
3286: WHERE
3287: rt5.transaction_id = c_nqr_rec.parent_transaction_id;
3288: END IF;
3289:

Line 4398: from rcv_transactions rt2

4394: into l_wip_entity_id
4395: from
4396: (
4397: Select distinct wip_entity_id
4398: from rcv_transactions rt2
4399: where rt2.transaction_type in ('DELIVER')
4400: START WITH
4401: rt2.transaction_id = (select rcv_transaction_id
4402: from cst_rcv_acq_costs_adj craca2

Line 4722: -- transaction_id of rcv_transactions;

4718:
4719: -----------------------------------------------------------------
4720: -- Fix for bug 1758901
4721: -- source_line_id of wip_transactions corresponds to
4722: -- transaction_id of rcv_transactions;
4723: -- rcv_transaction_id of wip_transactions corresponds to
4724: -- interface_transaction_id of rcv_transactions
4725: -----------------------------------------------------------------
4726: /* Reversed above fix

Line 4724: -- interface_transaction_id of rcv_transactions

4720: -- Fix for bug 1758901
4721: -- source_line_id of wip_transactions corresponds to
4722: -- transaction_id of rcv_transactions;
4723: -- rcv_transaction_id of wip_transactions corresponds to
4724: -- interface_transaction_id of rcv_transactions
4725: -----------------------------------------------------------------
4726: /* Reversed above fix
4727: Source_line_id in WT corresponds to interface_transaction_id
4728: in rcv_transactions and rcv_transaction_id corresponds to the

Line 4728: in rcv_transactions and rcv_transaction_id corresponds to the

4724: -- interface_transaction_id of rcv_transactions
4725: -----------------------------------------------------------------
4726: /* Reversed above fix
4727: Source_line_id in WT corresponds to interface_transaction_id
4728: in rcv_transactions and rcv_transaction_id corresponds to the
4729: transaction_id in rcv_transactions.
4730: Bugfix 2541821
4731: */
4732:

Line 4729: transaction_id in rcv_transactions.

4725: -----------------------------------------------------------------
4726: /* Reversed above fix
4727: Source_line_id in WT corresponds to interface_transaction_id
4728: in rcv_transactions and rcv_transaction_id corresponds to the
4729: transaction_id in rcv_transactions.
4730: Bugfix 2541821
4731: */
4732:
4733: SELECT

Line 4758: -- Get the parent receive or match txn from RCV_TRANSACTIONS

4754:
4755: l_stmt_num := 30;
4756:
4757: ------------------------------------------------------------
4758: -- Get the parent receive or match txn from RCV_TRANSACTIONS
4759: ------------------------------------------------------------
4760:
4761: SELECT
4762: rt6.transaction_id,

Line 4768: rcv_transactions rt6,

4764: INTO
4765: l_par_txn,
4766: l_lcm_flag
4767: FROM
4768: rcv_transactions rt6,
4769: po_line_locations_all poll
4770: WHERE
4771: rt6.transaction_type in ('RECEIVE','MATCH')
4772: AND poll.line_location_id = rt6.po_line_location_id

Line 4931: rcv_transactions rcv,

4927: INTO
4928: l_tot_tax
4929: FROM
4930: po_distributions_all pod,
4931: rcv_transactions rcv,
4932: po_line_locations_all pll
4933: WHERE RCV.TRANSACTION_ID = i_rcv_txn_id
4934: AND POD.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID
4935: AND PLL.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID

Line 5068: rcv_transactions

5064: NVL(currency_conversion_rate, 1)
5065: INTO
5066: l_rcv_rate
5067: FROM
5068: rcv_transactions
5069: WHERE
5070: transaction_id = i_rcv_txn_id;
5071:
5072:

Line 5087: rcv_transactions rt

5083: l_rcv_rate
5084: FROM
5085: po_lines_all pol,
5086: po_line_locations_all poll,
5087: rcv_transactions rt
5088: WHERE
5089: rt.transaction_id = i_rcv_txn_id
5090: AND rt.po_line_location_id = poll.line_location_id
5091: AND pol.po_line_id = poll.po_line_id;

Line 5219: RCV_TRANSACTIONS RT,

5215: INTO
5216: l_po_rate
5217: FROM
5218: PO_DISTRIBUTIONS_ALL POD,
5219: RCV_TRANSACTIONS RT,
5220: PO_LINE_LOCATIONS_ALL POLL
5221: WHERE
5222: RT.TRANSACTION_ID = i_rcv_txn_id
5223: AND (

Line 5260: rcv_transactions rt4

5256: rt4.transaction_type,
5257: rt4.primary_quantity,
5258: rt4.parent_transaction_id
5259: FROM
5260: rcv_transactions rt4
5261: WHERE
5262: rt4.transaction_date < i_end_date
5263: START WITH
5264: rt4.transaction_id = i_transaction_id

Line 5268: l_parent_type rcv_transactions.transaction_type%TYPE;

5264: rt4.transaction_id = i_transaction_id
5265: CONNECT BY
5266: prior rt4.transaction_id = rt4.parent_transaction_id;
5267: l_nqud NUMBER := 0;
5268: l_parent_type rcv_transactions.transaction_type%TYPE;
5269: l_stmt_num NUMBER := 0;
5270: BEGIN
5271: ---------------------------------------------------------
5272: -- Initialize error variable

Line 5291: rcv_transactions rt5

5287: rt5.transaction_type
5288: INTO
5289: l_parent_type
5290: FROM
5291: rcv_transactions rt5
5292: WHERE
5293: rt5.transaction_id = c_nqud_rec.parent_transaction_id;
5294: END IF;
5295: ------------------------------------------------------------