[Home] [Help]
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
106: from ap_invoice_distributions_all aida
107: WHERE aida.rcv_transaction_id is not null
108: and i_invoice_no IS NULL
109: and i_receipt_no is NULL
110: and exists (select 1 from rcv_transactions rt,
111: po_line_locations_all poll, -- Added for Complex work Procurement
112: cst_cost_group_assignments ccga
113: where rt.transaction_id = aida.rcv_transaction_id
114: -- Added for Complex work Procurement
127: OR
128: ( rt.transaction_type = 'MATCH'))
129: )
130: AND NOT EXISTS ( SELECT 1
131: FROM RCV_TRANSACTIONS RT,
132: PO_DISTRIBUTIONS_ALL POD
133: WHERE RT.TRANSACTION_ID = AIDA.RCV_TRANSACTION_ID
134: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
135: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE'
135: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE'
136: )
137: /*bug 5044215/5264793.Only pick up receipts that have delivers */
138: AND EXISTS (Select 1
139: from rcv_transactions rt2
140: where rt2.transaction_type in ('DELIVER')
141: START WITH rt2.transaction_id = aida.rcv_transaction_id
142: CONNECT BY
143: prior rt2.transaction_id = rt2.parent_transaction_id
151: AND (aida2.accounting_date between l_start_date and l_end_date)
152: AND aida2.posted_flag = 'Y'
153: AND aida2.line_type_lookup_code <> 'REC_TAX'
154: )
155: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
156: WHERE rt.transaction_id = aida.rcv_transaction_id
157: AND rae.rcv_transaction_id = rt.transaction_id
158: AND rae.event_type_id = 1 -- RECEIVE
159: AND rae.trx_flow_header_id is not NULL)
165: and aida.line_type_lookup_code <> 'REC_TAX'
166: and aida.rcv_transaction_id is NOT NULL
167: and i_receipt_no IS NULL
168: and i_invoice_no IS NULL
169: and exists (select 1 from rcv_transactions rt,
170: po_line_locations_all poll, -- Added for Complex work Procurement
171: cst_cost_group_assignments ccga
172: where rt.transaction_id = aida.rcv_transaction_id
173: -- Added for Complex work Procurement
186: OR
187: ( rt.transaction_type = 'MATCH'))
188: )
189: AND NOT EXISTS ( SELECT 1
190: FROM RCV_TRANSACTIONS RT,
191: PO_DISTRIBUTIONS_ALL POD
192: WHERE RT.TRANSACTION_ID = AIDA.RCV_TRANSACTION_ID
193: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
194: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE' )
193: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
194: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE' )
195: /*bug 5044215/5264793.Only pick up receipts that have delivers */
196: AND EXISTS (Select 1
197: from rcv_transactions rt2
198: where rt2.transaction_type in ('DELIVER')
199: START WITH rt2.transaction_id = aida.rcv_transaction_id
200: CONNECT BY
201: prior rt2.transaction_id = rt2.parent_transaction_id
199: START WITH rt2.transaction_id = aida.rcv_transaction_id
200: CONNECT BY
201: prior rt2.transaction_id = rt2.parent_transaction_id
202: )
203: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
204: WHERE rt.transaction_id = aida.rcv_transaction_id
205: AND rae.rcv_transaction_id = rt.transaction_id
206: AND rae.event_type_id = 1 -- RECEIVE
207: AND rae.trx_flow_header_id is not NULL)
210: ( select i_receipt_no from dual
211: where i_receipt_no IS NOT NULL
212: /*bug 5044215/5264793.Only pick up receipts that have delivers */
213: AND EXISTS (Select 1
214: from rcv_transactions rt2
215: where rt2.transaction_type in ('DELIVER')
216: START WITH rt2.transaction_id = i_receipt_no
217: CONNECT BY
218: prior rt2.transaction_id = rt2.parent_transaction_id
217: CONNECT BY
218: prior rt2.transaction_id = rt2.parent_transaction_id
219: )
220: AND EXISTS ( Select 'not lcm enabled'
221: FROM rcv_transactions rt,
222: po_line_locations_all poll
223: WHERE rt.transaction_id = i_receipt_no
224: AND rt.po_line_location_id = poll.line_location_id
225: AND nvl(poll.lcm_flag,'N') = 'N'
232: where aida.invoice_id = i_invoice_no
233: and i_invoice_no IS NOT NULL
234: and aida.rcv_transaction_id IS NOT NULL
235: and aida.line_type_lookup_code = 'ITEM'
236: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
237: WHERE rt.transaction_id = aida.rcv_transaction_id
238: AND rae.rcv_transaction_id = rt.transaction_id
239: AND rae.event_type_id = 1 -- RECEIVE
240: AND rae.trx_flow_header_id is not NULL)
238: AND rae.rcv_transaction_id = rt.transaction_id
239: AND rae.event_type_id = 1 -- RECEIVE
240: AND rae.trx_flow_header_id is not NULL)
241: AND NOT EXISTS ( SELECT 1
242: FROM rcv_transactions rt,
243: po_distributions_all pod,
244: po_line_locations_all poll
245: WHERE rt.transaction_id = aida.rcv_transaction_id
246: AND pod.line_location_id = rt.po_line_location_id
248: AND nvl(poll.lcm_flag,'N') = 'Y'
249: AND pod.destination_type_code = 'EXPENSE' )
250: /*bug 5044215/5264793.Only pick up receipts that have delivers */
251: AND EXISTS (Select 1
252: from rcv_transactions rt2
253: where rt2.transaction_type in ('DELIVER')
254: START WITH rt2.transaction_id = aida.rcv_transaction_id
255: CONNECT BY
256: prior rt2.transaction_id = rt2.parent_transaction_id
281: max(clat.transaction_id) transaction_id
282: FROM cst_lc_adj_transactions clat,
283: cst_cost_group_assignments ccga1,
284: mtl_parameters mp,
285: rcv_transactions rt,
286: rcv_parameters rp,
287: mtl_system_items msi,
288: po_line_locations_all poll,
289: mtl_units_of_measure muom
330: sum(mmt.primary_quantity) primary_quantity
331: FROM ( SELECT po_distribution_id,
332: transaction_id,
333: organization_id
334: FROM rcv_transactions
335: WHERE transaction_type IN ('DELIVER','RETURN TO RECEIVING','CORRECT')
336: AND transaction_date < p_valuation_date
337: AND organization_id = p_organization_id
338: START WITH transaction_id = p_rcv_transaction_id
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;
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;
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;
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
656:
657: SELECT nvl(poll.match_option,'P')
658: INTO l_match_option
659: FROM po_line_locations_all poll,
660: rcv_transactions rt7
661: WHERE
662: poll.line_location_id = rt7.po_line_location_id
663: AND rt7.transaction_id = c_rec.transaction_id;
664:
671: l_stmt_num := 140;
672:
673: SELECT count(rt2.transaction_id)
674: INTO l_po_count
675: FROM rcv_transactions rt2,
676: po_lines_all pol1,
677: po_line_locations_all poll1
678: WHERE rt2.transaction_id = c_rec.transaction_id
679: AND rt2.po_line_location_id = poll1.line_location_id
701: l_poll_quantity,
702: l_org_id,
703: l_order_type_lookup_code
704: FROM
705: rcv_transactions rt3,
706: rcv_shipment_lines rsl,
707: po_line_locations_all poll2
708: WHERE
709: rt3.transaction_id = c_rec.transaction_id
753: l_order_type_lookup_code
754: FROM
755: po_lines_all pol2,
756: po_line_locations_all poll3,
757: rcv_transactions rt33
758: WHERE
759: rt33.transaction_id = c_rec.transaction_id
760: AND rt33.po_line_location_id = poll3.line_location_id
761: AND pol2.po_line_id = poll3.po_line_id;
940: nvl(ad2.base_amount, nvl(ad2.amount, 0)) base_amount
941: FROM
942: ap_invoice_distributions_all ad2,
943: -- J Changes -----------------------------------------------------------
944: RCV_TRANSACTIONS RT,
945: PO_LINES_ALL POL,
946: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
947: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
948: ------------------------------------------------------------------------
1199: l_rct_landed_cost NUMBER;
1200: l_rec_ct NUMBER;
1201: l_rct_adj_landed_cost NUMBER;
1202: l_lcm_acq_cost NUMBER;
1203: l_net_qty_rec rcv_transactions.quantity%TYPE := 0;
1204: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1205: l_nr_tax_rate NUMBER;
1206: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1207: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1206: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1207: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1208: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1209: l_po_price po_lines_all.unit_price%TYPE;
1210: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1211: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1212: l_item_id mtl_system_items.inventory_item_id%TYPE;
1213: l_org_id rcv_transactions.organization_id%TYPE;
1214: BEGIN
1209: l_po_price po_lines_all.unit_price%TYPE;
1210: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1211: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1212: l_item_id mtl_system_items.inventory_item_id%TYPE;
1213: l_org_id rcv_transactions.organization_id%TYPE;
1214: BEGIN
1215: l_stmt_num := 1000;
1216: SELECT count(rcv_transaction_id)
1217: INTO l_rec_ct
1226: IF l_rec_ct = 0 THEN /*Hook has not been used*/
1227: l_stmt_num := 1010;
1228: SELECT unit_landed_cost
1229: INTO l_rct_landed_cost
1230: FROM rcv_transactions
1231: WHERE transaction_id = c_rec.transaction_id;
1232: l_stmt_num := 1020;
1233:
1234: SELECT nvl(Max(new_landed_cost),-1)
1296: l_rate
1297: FROM
1298: po_lines_all pol2,
1299: po_line_locations_all poll3,
1300: rcv_transactions rt33
1301: WHERE rt33.transaction_id = c_rec.transaction_id
1302: AND rt33.po_line_location_id = poll3.line_location_id
1303: AND pol2.po_line_id = poll3.po_line_id;
1304:
2293:
2294: l_recs_processed := l_recs_processed + 1;
2295: DECLARE
2296: l_rec_ct NUMBER := 0;
2297: l_nqr rcv_transactions.quantity%TYPE := 0;
2298: l_inv_count number;
2299: l_header cst_rcv_acq_costs.header_id%TYPE;
2300: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2301: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2300: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2301: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2302: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2303: l_po_price po_lines_all.unit_price%TYPE;
2304: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2305: l_po_line_loc po_lines_all.po_line_id%TYPE;
2306: l_item_id mtl_system_items.inventory_item_id%TYPE;
2307: l_org_id rcv_transactions.organization_id%TYPE;
2308: l_poll_quantity po_line_locations_all.quantity%TYPE;
2303: l_po_price po_lines_all.unit_price%TYPE;
2304: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2305: l_po_line_loc po_lines_all.po_line_id%TYPE;
2306: l_item_id mtl_system_items.inventory_item_id%TYPE;
2307: l_org_id rcv_transactions.organization_id%TYPE;
2308: l_poll_quantity po_line_locations_all.quantity%TYPE;
2309: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
2310: l_po_count NUMBER; -- remove this later
2311: l_nr_tax_rate NUMBER;
2309: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
2310: l_po_count NUMBER; -- remove this later
2311: l_nr_tax_rate NUMBER;
2312: l_match_option po_line_locations_all.match_option%TYPE;
2313: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
2314: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
2315:
2316: BEGIN
2317: If G_DEBUG ='Y' then
2449:
2450: SELECT nvl(poll.match_option,'P')
2451: INTO l_match_option
2452: FROM po_line_locations_all poll,
2453: rcv_transactions rt7
2454: WHERE
2455: poll.line_location_id = rt7.po_line_location_id
2456: AND rt7.transaction_id = c_rec.transaction_id;
2457:
2464: l_stmt_num := 141;
2465:
2466: SELECT count(rt2.transaction_id)
2467: INTO l_po_count
2468: FROM rcv_transactions rt2,
2469: po_lines_all pol1,
2470: po_line_locations_all poll1
2471: WHERE rt2.transaction_id = c_rec.transaction_id
2472: AND rt2.po_line_location_id = poll1.line_location_id
2494: l_poll_quantity,
2495: l_org_id,
2496: l_order_type_lookup_code
2497: FROM
2498: rcv_transactions rt3,
2499: rcv_shipment_lines rsl,
2500: po_line_locations_all poll2
2501: WHERE
2502: rt3.transaction_id = c_rec.transaction_id
2546: l_order_type_lookup_code
2547: FROM
2548: po_lines_all pol2,
2549: po_line_locations_all poll3,
2550: rcv_transactions rt33
2551: WHERE
2552: rt33.transaction_id = c_rec.transaction_id
2553: AND rt33.po_line_location_id = poll3.line_location_id
2554: AND pol2.po_line_id = poll3.po_line_id;
2733: nvl(ad2.base_amount, nvl(ad2.amount, 0)) base_amount
2734: FROM
2735: ap_invoice_distributions_all ad2,
2736: -- J Changes -----------------------------------------------------------
2737: RCV_TRANSACTIONS RT,
2738: PO_LINES_ALL POL,
2739: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
2740: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
2741: ------------------------------------------------------------------------
3095: SELECT RT.TRANSACTION_ID,
3096: RT.TRANSACTION_TYPE,
3097: RT.AMOUNT,
3098: RT.PARENT_TRANSACTION_ID
3099: FROM RCV_TRANSACTIONS RT
3100: WHERE ( ( (i_source_flag = 1)
3101: AND ( ( (i_res_flag =1)
3102: AND (rt.transaction_date between i_start_date and i_end_date))
3103: OR (i_res_flag = 2)))
3114: rt4.primary_quantity,
3115: rt4.quantity,/* ADDED FOR #BUG6697382*/
3116: rt4.parent_transaction_id
3117: FROM
3118: rcv_transactions rt4
3119: WHERE
3120: (((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)))
3121: START WITH
3122: rt4.transaction_id = i_transaction_id
3125:
3126: l_nqr NUMBER := 0;
3127: l_actual_nqr NUMBER:=0;/* ADDED FOR #BUG6679382*/
3128: l_po_line_type_code VARCHAR2(25);
3129: l_parent_type rcv_transactions.transaction_type%TYPE;
3130: l_stmt_num NUMBER := 0;
3131: BEGIN
3132:
3133: ---------------------------------------------------------
3148: SELECT NVL(POLL.MATCHING_BASIS, POL.MATCHING_BASIS) -- Changed for Complex work Procurement
3149: INTO L_PO_LINE_TYPE_CODE
3150: FROM PO_LINES_ALL POL,
3151: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
3152: RCV_TRANSACTIONS RT
3153: WHERE POL.PO_LINE_ID = RT.PO_LINE_ID
3154: AND POLL.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID-- Added for Complex work Procurement
3155: AND RT.TRANSACTION_ID = I_TRANSACTION_ID;
3156:
3162: l_stmt_num := 20;
3163:
3164: SELECT transaction_type
3165: INTO l_parent_type
3166: FROM rcv_transactions
3167: WHERE transaction_id = c_amount_rec.parent_transaction_id;
3168: END IF;
3169:
3170: IF c_amount_rec.transaction_id = i_transaction_id THEN
3198: rt5.transaction_type
3199: INTO
3200: l_parent_type
3201: FROM
3202: rcv_transactions rt5
3203: WHERE
3204: rt5.transaction_id = c_nqr_rec.parent_transaction_id;
3205: END IF;
3206:
4303: into l_wip_entity_id
4304: from
4305: (
4306: Select distinct wip_entity_id
4307: from rcv_transactions rt2
4308: where rt2.transaction_type in ('DELIVER')
4309: START WITH
4310: rt2.transaction_id = (select rcv_transaction_id
4311: from cst_rcv_acq_costs_adj craca2
4573:
4574: -----------------------------------------------------------------
4575: -- Fix for bug 1758901
4576: -- source_line_id of wip_transactions corresponds to
4577: -- transaction_id of rcv_transactions;
4578: -- rcv_transaction_id of wip_transactions corresponds to
4579: -- interface_transaction_id of rcv_transactions
4580: -----------------------------------------------------------------
4581: /* Reversed above fix
4575: -- Fix for bug 1758901
4576: -- source_line_id of wip_transactions corresponds to
4577: -- transaction_id of rcv_transactions;
4578: -- rcv_transaction_id of wip_transactions corresponds to
4579: -- interface_transaction_id of rcv_transactions
4580: -----------------------------------------------------------------
4581: /* Reversed above fix
4582: Source_line_id in WT corresponds to interface_transaction_id
4583: in rcv_transactions and rcv_transaction_id corresponds to the
4579: -- interface_transaction_id of rcv_transactions
4580: -----------------------------------------------------------------
4581: /* Reversed above fix
4582: Source_line_id in WT corresponds to interface_transaction_id
4583: in rcv_transactions and rcv_transaction_id corresponds to the
4584: transaction_id in rcv_transactions.
4585: Bugfix 2541821
4586: */
4587:
4580: -----------------------------------------------------------------
4581: /* Reversed above fix
4582: Source_line_id in WT corresponds to interface_transaction_id
4583: in rcv_transactions and rcv_transaction_id corresponds to the
4584: transaction_id in rcv_transactions.
4585: Bugfix 2541821
4586: */
4587:
4588: SELECT
4609:
4610: l_stmt_num := 30;
4611:
4612: ------------------------------------------------------------
4613: -- Get the parent receive or match txn from RCV_TRANSACTIONS
4614: ------------------------------------------------------------
4615:
4616: SELECT
4617: rt6.transaction_id,
4619: INTO
4620: l_par_txn,
4621: l_lcm_flag
4622: FROM
4623: rcv_transactions rt6,
4624: po_line_locations_all poll
4625: WHERE
4626: rt6.transaction_type in ('RECEIVE','MATCH')
4627: AND poll.line_location_id = rt6.po_line_location_id
4782: INTO
4783: l_tot_tax
4784: FROM
4785: po_distributions_all pod,
4786: rcv_transactions rcv,
4787: po_line_locations_all pll
4788: WHERE RCV.TRANSACTION_ID = i_rcv_txn_id
4789: AND POD.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID
4790: AND PLL.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID
4903: INTO
4904: l_po_rate
4905: FROM
4906: PO_DISTRIBUTIONS_ALL POD,
4907: RCV_TRANSACTIONS RT,
4908: PO_LINE_LOCATIONS_ALL POLL
4909: WHERE
4910: RT.TRANSACTION_ID = i_rcv_txn_id
4911: AND (
4944: rt4.transaction_type,
4945: rt4.primary_quantity,
4946: rt4.parent_transaction_id
4947: FROM
4948: rcv_transactions rt4
4949: WHERE
4950: rt4.transaction_date < i_end_date
4951: START WITH
4952: rt4.transaction_id = i_transaction_id
4952: rt4.transaction_id = i_transaction_id
4953: CONNECT BY
4954: prior rt4.transaction_id = rt4.parent_transaction_id;
4955: l_nqud NUMBER := 0;
4956: l_parent_type rcv_transactions.transaction_type%TYPE;
4957: l_stmt_num NUMBER := 0;
4958: BEGIN
4959: ---------------------------------------------------------
4960: -- Initialize error variable
4975: rt5.transaction_type
4976: INTO
4977: l_parent_type
4978: FROM
4979: rcv_transactions rt5
4980: WHERE
4981: rt5.transaction_id = c_nqud_rec.parent_transaction_id;
4982: END IF;
4983: ------------------------------------------------------------