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.GMF_RCV_ACCOUNTING_PKG dependencies on RCV_TRANSACTIONS

Line 68: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;

64: l_transaction_amount NUMBER;
65: l_po_amount_ordered NUMBER;
66: l_po_amount_delivered NUMBER;
67: l_abs_rt_amount NUMBER;
68: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
69: l_parent_txn_id NUMBER;
70: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
71: BEGIN
72: /**********************************

Line 70: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;

66: l_po_amount_delivered NUMBER;
67: l_abs_rt_amount NUMBER;
68: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
69: l_parent_txn_id NUMBER;
70: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
71: BEGIN
72: /**********************************
73: * Standard start of API savepoint *
74: **********************************/

Line 116: FROM rcv_transactions RT,

112: **************************************************************************************/
113: l_stmt_num := 10;
114: SELECT decode(RT.po_distribution_id, NULL, RT.amount * (POD.amount_ordered/POLL.amount),RT.amount)
115: INTO l_transaction_amount
116: FROM rcv_transactions RT,
117: po_distributions POD,
118: po_line_locations POLL
119: WHERE RT.transaction_id = p_rcv_accttxn.rcv_transaction_id
120: AND POD.po_distribution_id = p_rcv_accttxn.po_distribution_id

Line 150: FROM rcv_transactions RT

146:
147: l_stmt_num := 40;
148: SELECT RT.transaction_type, RT.parent_transaction_id
149: INTO l_rcv_txn_type, l_parent_txn_id
150: FROM rcv_transactions RT
151: WHERE RT.transaction_id = p_rcv_accttxn.rcv_transaction_id;
152:
153: l_stmt_num := 50;
154: SELECT PARENT.transaction_type

Line 156: FROM rcv_transactions PARENT

152:
153: l_stmt_num := 50;
154: SELECT PARENT.transaction_type
155: INTO l_par_rcv_txn_type
156: FROM rcv_transactions PARENT
157: WHERE PARENT.transaction_id =l_parent_txn_id;
158:
159: l_stmt_num := 60;
160: SELECT POD.amount_ordered, POD.amount_delivered

Line 461: l_rcv_txn_type rcv_transactions.transaction_type%TYPE;

457: l_source_doc_quantity NUMBER;
458: l_po_quantity_ordered NUMBER;
459: l_po_quantity_delivered NUMBER;
460: l_abs_rt_quantity NUMBER;
461: l_rcv_txn_type rcv_transactions.transaction_type%TYPE;
462: l_parent_txn_id NUMBER;
463: l_par_rcv_txn_type rcv_transactions.transaction_type%TYPE;
464: BEGIN
465: /**********************************

Line 463: l_par_rcv_txn_type rcv_transactions.transaction_type%TYPE;

459: l_po_quantity_delivered NUMBER;
460: l_abs_rt_quantity NUMBER;
461: l_rcv_txn_type rcv_transactions.transaction_type%TYPE;
462: l_parent_txn_id NUMBER;
463: l_par_rcv_txn_type rcv_transactions.transaction_type%TYPE;
464: BEGIN
465: /**********************************
466: * Standard start of API savepoint *
467: **********************************/

Line 511: FROM rcv_transactions rt,

507: / poll.quantity,
508: rt.source_doc_quantity
509: )
510: INTO l_source_doc_quantity
511: FROM rcv_transactions rt,
512: po_line_locations poll,
513: po_distributions pod
514: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
515: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id

Line 545: FROM rcv_transactions rt,

541: / poll.quantity,
542: l_source_doc_quantity
543: )
544: INTO l_source_doc_quantity
545: FROM rcv_transactions rt,
546: po_line_locations poll,
547: po_distributions pod
548: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
549: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id

Line 564: FROM rcv_transactions rt

560: l_stmt_num := 60;
561:
562: SELECT rt.transaction_type, rt.parent_transaction_id
563: INTO l_rcv_txn_type, l_parent_txn_id
564: FROM rcv_transactions rt
565: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id;
566:
567: l_stmt_num := 70;
568:

Line 571: FROM rcv_transactions PARENT

567: l_stmt_num := 70;
568:
569: SELECT PARENT.transaction_type
570: INTO l_par_rcv_txn_type
571: FROM rcv_transactions PARENT
572: WHERE PARENT.transaction_id = l_parent_txn_id;
573:
574: l_stmt_num := 80;
575:

Line 955: FROM rcv_transactions rt, mtl_units_of_measure muom

951: -- The l_ic_pricing_option can only be 2 for a source type of 'RECEIVING'.
952: -- Get the UOM of the source_doc since unit price is desired in Document's UOM
953: SELECT muom.uom_code
954: INTO l_transaction_uom
955: FROM rcv_transactions rt, mtl_units_of_measure muom
956: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
957: AND muom.unit_of_measure = rt.source_doc_unit_of_measure;
958:
959: -- While calling the transfer pricing API, the from organization id should be

Line 1785: -- rcv_transactions.curr_conv_rate--

1781: -- --
1782: -- Logic: --
1783: -- If supplier facing org, if match to po use POD.rate --
1784: -- else --
1785: -- rcv_transactions.curr_conv_rate--
1786: -- Else --
1787: -- Get the conversion type --
1788: -- Determine currency conversion rate --
1789: -- --

Line 1916: FROM rcv_transactions rt

1912: SELECT rt.currency_conversion_rate, rt.currency_conversion_type,
1913: rt.currency_conversion_date
1914: INTO l_currency_conversion_rate, l_currency_conversion_type,
1915: l_currency_conversion_date
1916: FROM rcv_transactions rt
1917: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id;
1918: END IF;
1919: ELSE
1920: l_currency_code := p_rcv_accttxn.currency_code;

Line 2126: l_trx_type rcv_transactions.transaction_type%TYPE;

2122: l_receiving_insp_acct_id NUMBER;
2123: l_clearing_acct_id NUMBER;
2124: l_retroprice_adj_acct_id NUMBER;
2125: l_overlaid_acct NUMBER;
2126: l_trx_type rcv_transactions.transaction_type%TYPE;
2127: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
2128: l_parent_trx_id NUMBER;
2129: l_account_flag NUMBER := 0;
2130: BEGIN

Line 2127: l_parent_trx_type rcv_transactions.transaction_type%TYPE;

2123: l_clearing_acct_id NUMBER;
2124: l_retroprice_adj_acct_id NUMBER;
2125: l_overlaid_acct NUMBER;
2126: l_trx_type rcv_transactions.transaction_type%TYPE;
2127: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
2128: l_parent_trx_id NUMBER;
2129: l_account_flag NUMBER := 0;
2130: BEGIN
2131: -- Standard start of API savepoint

Line 2248: FROM rcv_transactions trx, rcv_transactions parent_trx

2244: l_stmt_num := 40;
2245:
2246: SELECT parent_trx.transaction_type
2247: INTO l_parent_trx_type
2248: FROM rcv_transactions trx, rcv_transactions parent_trx
2249: WHERE trx.transaction_id = p_rcv_accttxn.rcv_transaction_id
2250: AND trx.parent_transaction_id = parent_trx.transaction_id;
2251: END IF;
2252:

Line 2599: FROM rcv_transactions rt

2595: l_stmt_num := 140;
2596:
2597: SELECT rt.transaction_type, rt.parent_transaction_id
2598: INTO l_trx_type, l_parent_trx_id
2599: FROM rcv_transactions rt
2600: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id;
2601:
2602: IF (l_trx_type = 'DELIVER')
2603: THEN

Line 2616: FROM rcv_transactions parent_trx

2612: l_stmt_num := 150;
2613:
2614: SELECT parent_trx.transaction_type
2615: INTO l_parent_trx_type
2616: FROM rcv_transactions parent_trx
2617: WHERE parent_trx.transaction_id = l_parent_trx_id;
2618:
2619: IF (l_parent_trx_type = 'DELIVER')
2620: THEN

Line 2852: FROM rcv_transactions rt, rcv_shipment_lines rsl

2848: l_stmt_num := 20;
2849:
2850: SELECT rsl.ussgl_transaction_code
2851: INTO l_ussgl_tc
2852: FROM rcv_transactions rt, rcv_shipment_lines rsl
2853: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
2854: AND rt.shipment_line_id = rsl.shipment_line_id;
2855: END IF;
2856: END IF;

Line 3371: FROM rcv_transactions rt,

3367: l_inv_trx.intercompany_currency_code,
3368: l_inv_trx.distribution_account_id, l_inv_trx.costed_flag,
3369: l_inv_trx.subinventory_code, l_inv_trx.locator_id,
3370: l_inv_trx.parent_transaction_flag, l_inv_trx.trx_source_line_id
3371: FROM rcv_transactions rt,
3372: po_lines pol,
3373: po_line_locations poll,
3374: po_distributions pod,
3375: fnd_currencies fc

Line 3604: l_rcv_txn_type rcv_transactions.transaction_type%TYPE;

3600: l_inv_trx_tbl_ctr BINARY_INTEGER;
3601: l_correct_ind BOOLEAN := FALSE;
3602: -- indicator variable for whether these
3603: -- transactions are for a correction or not
3604: l_rcv_txn_type rcv_transactions.transaction_type%TYPE;
3605: l_parent_txn_flag NUMBER := 1;
3606: l_intercompany_price NUMBER;
3607: -- may include nr tax depending on the pricing option
3608: l_intercompany_curr_code gmf_rcv_accounting_txns.currency_code%TYPE;

Line 3655: FROM rcv_transactions

3651:
3652: -- Determine if this group of transactions are for a CORRECT txn type
3653: SELECT transaction_type
3654: INTO l_rcv_txn_type
3655: FROM rcv_transactions
3656: WHERE transaction_id = p_rcv_accttxn_tbl (l_ctr).rcv_transaction_id;
3657:
3658: IF (l_rcv_txn_type = 'CORRECT')
3659: THEN

Line 4447: FROM rcv_transactions rt,

4443: l_rcv_accttxn.destination_type_code,
4444: /* start LCM-OPM Integration */
4445: l_rcv_accttxn.unit_landed_cost
4446: /* end LCM-OPM Integration */
4447: FROM rcv_transactions rt,
4448: po_lines pol,
4449: po_line_locations poll,
4450: po_headers poh,
4451: po_distributions pod

Line 5510: rcv_transactions rt

5506: l_project_id, l_accrual_flag
5507: FROM po_headers poh,
5508: po_line_locations poll,
5509: po_lines pol,
5510: rcv_transactions rt
5511: WHERE rt.transaction_id = p_rcv_transaction_id
5512: AND poh.po_header_id = rt.po_header_id
5513: AND poll.line_location_id = rt.po_line_location_id
5514: AND pol.po_line_id = rt.po_line_id;

Line 6016: FROM rcv_transactions rt

6012: l_stmt_num := 130;
6013:
6014: SELECT DECODE (rt.transaction_type, 'CORRECT', correct, receive)
6015: INTO l_event_type_id
6016: FROM rcv_transactions rt
6017: WHERE transaction_id = p_rcv_transaction_id;
6018:
6019: IF g_debug = 'Y'
6020: AND fnd_log.level_event >= fnd_log.g_current_runtime_level

Line 6313: rcv_transactions rt

6309: FROM po_headers poh,
6310: po_line_locations poll,
6311: po_lines pol,
6312: po_distributions pod,
6313: rcv_transactions rt
6314: WHERE rt.transaction_id = p_rcv_transaction_id
6315: AND poh.po_header_id = rt.po_header_id
6316: AND poll.line_location_id = rt.po_line_location_id
6317: AND pol.po_line_id = rt.po_line_id

Line 6493: FROM rcv_transactions rt

6489: /* Following SELECT commented and substituted with subsequent code */
6490: /*
6491: SELECT DECODE (rt.transaction_type, 'CORRECT', correct, deliver)
6492: INTO l_event_type_id
6493: FROM rcv_transactions rt
6494: WHERE transaction_id = p_rcv_transaction_id;
6495: */
6496:
6497: SELECT NVL(quantity,0), transaction_type

Line 6499: FROM rcv_transactions rt

6495: */
6496:
6497: SELECT NVL(quantity,0), transaction_type
6498: INTO l_rcv_quantity, l_rcv_transaction_type
6499: FROM rcv_transactions rt
6500: WHERE transaction_id = p_rcv_transaction_id;
6501:
6502: IF l_rcv_transaction_type = 'CORRECT' THEN
6503: IF l_rcv_quantity < 0 THEN

Line 6884: rcv_transactions rt

6880: FROM po_headers poh,
6881: po_line_locations poll,
6882: po_lines pol,
6883: po_distributions pod,
6884: rcv_transactions rt
6885: WHERE rt.transaction_id = p_rcv_transaction_id
6886: AND poh.po_header_id = rt.po_header_id
6887: AND poll.line_location_id = rt.po_line_location_id
6888: AND pol.po_line_id = rt.po_line_id

Line 7081: FROM rcv_transactions rt

7077: 'CORRECT', correct,
7078: return_to_receiving
7079: )
7080: INTO l_event_type_id
7081: FROM rcv_transactions rt
7082: WHERE transaction_id = p_rcv_transaction_id;
7083:
7084: l_stmt_num := 60;
7085:

Line 7511: rcv_transactions rt

7507: l_project_id, l_accrual_flag
7508: FROM po_headers poh,
7509: po_line_locations poll,
7510: po_lines pol,
7511: rcv_transactions rt
7512: WHERE rt.transaction_id = p_rcv_transaction_id
7513: AND poh.po_header_id = rt.po_header_id
7514: AND poll.line_location_id = rt.po_line_location_id
7515: AND pol.po_line_id = rt.po_line_id;

Line 7935: FROM rcv_transactions rt

7931: 'CORRECT', correct,
7932: return_to_vendor
7933: )
7934: INTO l_event_type_id
7935: FROM rcv_transactions rt
7936: WHERE transaction_id = p_rcv_transaction_id;
7937:
7938: IF g_debug = 'Y'
7939: AND fnd_log.level_event >= fnd_log.g_current_runtime_level

Line 8155: l_consigned_flag rcv_transactions.consigned_flag%TYPE;

8151: IS
8152: c_log_module CONSTANT VARCHAR2 (80)
8153: := module || '.create_accounting_txns';
8154: l_stmt_num NUMBER (10) := 0;
8155: l_consigned_flag rcv_transactions.consigned_flag%TYPE;
8156: l_source_doc_code rcv_transactions.source_document_code%TYPE;
8157: l_transaction_type rcv_transactions.transaction_type%TYPE;
8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;
8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;

Line 8156: l_source_doc_code rcv_transactions.source_document_code%TYPE;

8152: c_log_module CONSTANT VARCHAR2 (80)
8153: := module || '.create_accounting_txns';
8154: l_stmt_num NUMBER (10) := 0;
8155: l_consigned_flag rcv_transactions.consigned_flag%TYPE;
8156: l_source_doc_code rcv_transactions.source_document_code%TYPE;
8157: l_transaction_type rcv_transactions.transaction_type%TYPE;
8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;
8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;

Line 8157: l_transaction_type rcv_transactions.transaction_type%TYPE;

8153: := module || '.create_accounting_txns';
8154: l_stmt_num NUMBER (10) := 0;
8155: l_consigned_flag rcv_transactions.consigned_flag%TYPE;
8156: l_source_doc_code rcv_transactions.source_document_code%TYPE;
8157: l_transaction_type rcv_transactions.transaction_type%TYPE;
8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;
8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;

Line 8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;

8154: l_stmt_num NUMBER (10) := 0;
8155: l_consigned_flag rcv_transactions.consigned_flag%TYPE;
8156: l_source_doc_code rcv_transactions.source_document_code%TYPE;
8157: l_transaction_type rcv_transactions.transaction_type%TYPE;
8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;
8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8162: l_po_header_id po_headers_all.po_header_id%TYPE;

Line 8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;

8155: l_consigned_flag rcv_transactions.consigned_flag%TYPE;
8156: l_source_doc_code rcv_transactions.source_document_code%TYPE;
8157: l_transaction_type rcv_transactions.transaction_type%TYPE;
8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;
8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8162: l_po_header_id po_headers_all.po_header_id%TYPE;
8163: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;

Line 8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;

8156: l_source_doc_code rcv_transactions.source_document_code%TYPE;
8157: l_transaction_type rcv_transactions.transaction_type%TYPE;
8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;
8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8162: l_po_header_id po_headers_all.po_header_id%TYPE;
8163: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8164: l_shipment_type po_line_locations_all.shipment_type%TYPE;

Line 8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;

8157: l_transaction_type rcv_transactions.transaction_type%TYPE;
8158: l_parent_trx_id rcv_transactions.transaction_id%TYPE;
8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8162: l_po_header_id po_headers_all.po_header_id%TYPE;
8163: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8164: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8165: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

Line 8208: FROM rcv_transactions rt

8204: rt.po_line_location_id --12i Complex Work Procurement
8205: INTO l_consigned_flag, l_source_doc_code, l_transaction_type,
8206: l_parent_trx_id, l_po_header_id,
8207: l_po_line_location_id --12i Complex Work Procurement
8208: FROM rcv_transactions rt
8209: WHERE transaction_id = p_rcv_transaction_id;
8210:
8211: -- If receiving transaction is for a REQ, or an RMA, we do not
8212: -- do not do any accounting.

Line 8231: FROM rcv_transactions

8227:
8228: -- Get Parent Transaction Type
8229: SELECT transaction_type, parent_transaction_id
8230: INTO l_parent_trx_type, l_grparent_trx_id
8231: FROM rcv_transactions
8232: WHERE transaction_id = l_parent_trx_id;
8233:
8234: IF (l_grparent_trx_id NOT IN (0, -1))
8235: THEN

Line 8241: FROM rcv_transactions

8237:
8238: -- Get Grand Parent Transaction Type
8239: SELECT transaction_type
8240: INTO l_grparent_trx_type
8241: FROM rcv_transactions
8242: WHERE transaction_id = l_grparent_trx_id;
8243: END IF;
8244: END IF;
8245:

Line 8544: FROM rcv_transactions a, mtl_parameters b

8540: -- for a given po_header or po_release
8541: CURSOR c_parent_receive_txns_csr
8542: IS
8543: SELECT a.transaction_id, a.organization_id
8544: FROM rcv_transactions a, mtl_parameters b
8545: WHERE (
8546: (a.transaction_type = 'RECEIVE' AND a.parent_transaction_id = -1)
8547: OR
8548: a.transaction_type = 'MATCH'

Line 8562: FROM rcv_transactions a, mtl_parameters b

8558: -- a parent receive transaction.
8559: CURSOR c_deliver_txns_csr (l_par_txn IN NUMBER)
8560: IS
8561: SELECT a.transaction_id, a.po_distribution_id
8562: FROM rcv_transactions a, mtl_parameters b
8563: WHERE a.transaction_type = 'DELIVER'
8564: AND a.organization_id = b.organization_id
8565: AND NVL(b.process_enabled_flag, 'N') = 'Y'
8566: AND a.parent_transaction_id = l_par_txn;

Line 8576: rcv_transactions rt

8572: IS
8573: SELECT pod.po_distribution_id
8574: FROM po_distributions pod,
8575: po_line_locations poll,
8576: rcv_transactions rt
8577: WHERE pod.line_location_id = poll.line_location_id
8578: AND poll.line_location_id = rt.po_line_location_id
8579: AND rt.transaction_id = l_rcv_txn;
8580: BEGIN

Line 8730: -- GRAT for a particular Receive transaction in RCV_TRANSACTIONS

8726:
8727: IF l_rae_count > 0
8728: THEN
8729: -- Rownum check is there since there might be multiple events in
8730: -- GRAT for a particular Receive transaction in RCV_TRANSACTIONS
8731: l_stmt_num := 60;
8732:
8733: SELECT grat.organization_id, grat.trx_flow_header_id,
8734: NVL (rt.dropship_type_code, 3)

Line 8737: FROM gmf_rcv_accounting_txns grat, rcv_transactions rt

8733: SELECT grat.organization_id, grat.trx_flow_header_id,
8734: NVL (rt.dropship_type_code, 3)
8735: INTO l_organization_id, l_trx_flow_header_id,
8736: l_drop_ship_flag
8737: FROM gmf_rcv_accounting_txns grat, rcv_transactions rt
8738: WHERE grat.rcv_transaction_id = c_par_txn.transaction_id
8739: AND rt.transaction_id = grat.rcv_transaction_id
8740: AND grat.procurement_org_flag = 'Y'
8741: AND ROWNUM = 1;

Line 8747: -- If RCV_TRANSACTIONS has the po_distribution_id populated, we

8743: l_organization_id := c_par_txn.organization_id;
8744: END IF;
8745:
8746: -- One event is seeded per PO distribution
8747: -- If RCV_TRANSACTIONS has the po_distribution_id populated, we
8748: -- use that. Otherwise, we use cursor c_po_dists_csr to seed as many events
8749: -- as the number of distributions for the line_location
8750: l_stmt_num := 70;
8751:

Line 8754: FROM rcv_transactions

8750: l_stmt_num := 70;
8751:
8752: SELECT NVL (po_distribution_id, -1)
8753: INTO l_po_distribution_id
8754: FROM rcv_transactions
8755: WHERE transaction_id = c_par_txn.transaction_id;
8756:
8757: IF l_po_distribution_id <> -1
8758: THEN