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

Line 284: FROM rcv_transactions RT,

280: l_rcv_event.currency_code,
281: l_rcv_event.destination_type_code,
282: /* Support for Landed Cost Management */
283: l_rcv_event.unit_landed_cost
284: FROM rcv_transactions RT,
285: po_lines POL,
286: po_line_locations POLL,
287: po_headers POH,
288: po_distributions POD

Line 740: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;

736: l_po_amount_ordered NUMBER;
737: l_po_amount_delivered NUMBER;
738: l_abs_rt_amount NUMBER;
739:
740: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
741: l_parent_txn_id NUMBER;
742: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
743:
744: BEGIN

Line 742: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;

738: l_abs_rt_amount NUMBER;
739:
740: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
741: l_parent_txn_id NUMBER;
742: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
743:
744: BEGIN
745: -- Standard start of API savepoint
746: SAVEPOINT Get_TransactionAmount_PVT;

Line 784: FROM rcv_transactions RT,

780: SELECT decode(RT.po_distribution_id, NULL,
781: RT.amount * (POD.amount_ordered/POLL.amount),
782: RT.amount)
783: INTO l_transaction_amount
784: FROM rcv_transactions RT,
785: po_distributions POD,
786: po_line_locations POLL
787: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
788: AND POD.po_distribution_id = p_rcv_event.po_distribution_id

Line 819: FROM rcv_transactions RT

815:
816: l_stmt_num := 40;
817: SELECT RT.transaction_type, RT.parent_transaction_id
818: INTO l_rcv_txn_type, l_parent_txn_id
819: FROM rcv_transactions RT
820: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id;
821:
822: l_stmt_num := 50;
823: SELECT PARENT.transaction_type

Line 825: FROM rcv_transactions PARENT

821:
822: l_stmt_num := 50;
823: SELECT PARENT.transaction_type
824: INTO l_par_rcv_txn_type
825: FROM rcv_transactions PARENT
826: WHERE PARENT.transaction_id =l_parent_txn_id;
827:
828: l_stmt_num := 60;
829: SELECT POD.amount_ordered, POD.amount_delivered

Line 995: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;

991: l_po_quantity_ordered NUMBER;
992: l_po_quantity_delivered NUMBER;
993: l_abs_rt_quantity NUMBER;
994:
995: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
996: l_parent_txn_id NUMBER;
997: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
998:
999:

Line 997: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;

993: l_abs_rt_quantity NUMBER;
994:
995: l_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
996: l_parent_txn_id NUMBER;
997: l_par_rcv_txn_type RCV_Transactions.transaction_type%TYPE;
998:
999:
1000: BEGIN
1001: -- Standard start of API savepoint

Line 1037: FROM rcv_transactions RT,

1033: SELECT decode(RT.po_distribution_id, NULL,
1034: RT.source_doc_quantity * POD.quantity_ordered/POLL.quantity,
1035: RT.source_doc_quantity)
1036: INTO l_source_doc_quantity
1037: FROM rcv_transactions RT,
1038: po_line_locations POLL,
1039: po_distributions POD
1040: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
1041: AND POLL.line_location_id = p_rcv_event.po_line_location_id

Line 1058: FROM rcv_transactions RT,

1054: SELECT decode(RT.po_distribution_id, NULL,
1055: l_source_doc_quantity * POD.quantity_ordered/POLL.quantity,
1056: l_source_doc_quantity)
1057: INTO l_source_doc_quantity
1058: FROM rcv_transactions RT,
1059: po_line_locations POLL,
1060: po_distributions POD
1061: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
1062: AND POLL.line_location_id = p_rcv_event.po_line_location_id

Line 1077: FROM rcv_transactions RT

1073:
1074: l_stmt_num := 60;
1075: SELECT RT.transaction_type, RT.parent_transaction_id
1076: INTO l_rcv_txn_type, l_parent_txn_id
1077: FROM rcv_transactions RT
1078: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id;
1079:
1080: l_stmt_num := 70;
1081: SELECT PARENT.transaction_type

Line 1083: FROM rcv_transactions PARENT

1079:
1080: l_stmt_num := 70;
1081: SELECT PARENT.transaction_type
1082: INTO l_par_rcv_txn_type
1083: FROM rcv_transactions PARENT
1084: WHERE PARENT.transaction_id =l_parent_txn_id;
1085:
1086: l_stmt_num := 80;
1087: SELECT POD.quantity_ordered, POD.quantity_delivered

Line 1402: FROM rcv_transactions RT, mtl_units_of_measure MUOM

1398: -- The l_ic_pricing_option can only be 2 for a source type of 'RECEIVING'.
1399: -- Get the UOM of the source_doc since unit price is desired in Document's UOM
1400: SELECT MUOM.uom_code
1401: INTO l_transaction_uom
1402: FROM rcv_transactions RT, mtl_units_of_measure MUOM
1403: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
1404: AND MUOM.unit_of_measure = RT.source_doc_unit_of_measure;
1405:
1406: -- While calling the transfer pricing API, the from organization id should be

Line 1491: FROM rcv_transactions

1487: /* Support for Landed Cost Management */
1488: IF (p_rcv_event.event_source = 'RECEIVING' AND p_lcm_flag = 'Y') THEN
1489: SELECT unit_landed_cost
1490: INTO x_unit_landed_cost
1491: FROM rcv_transactions
1492: WHERE transaction_id = p_rcv_event.rcv_transaction_id;
1493:
1494: END IF;
1495:

Line 2141: -- rcv_transactions.curr_conv_rate--

2137: -- --
2138: -- Logic: --
2139: -- If supplier facing org, if match to po use POD.rate --
2140: -- else --
2141: -- rcv_transactions.curr_conv_rate--
2142: -- Else --
2143: -- Get the conversion type --
2144: -- Determine currency conversion rate --
2145: -- --

Line 2193: l_currency_code RCV_TRANSACTIONS.currency_code%TYPE;

2189: l_api_message VARCHAR2(1000);
2190:
2191: -- local data variables
2192: l_match_option VARCHAR2(1);
2193: l_currency_code RCV_TRANSACTIONS.currency_code%TYPE;
2194: l_currency_conversion_rate NUMBER;
2195: l_currency_conversion_date DATE;
2196: l_currency_conversion_type RCV_TRANSACTIONS.currency_conversion_type%TYPE := '';
2197: l_sob_id NUMBER;

Line 2196: l_currency_conversion_type RCV_TRANSACTIONS.currency_conversion_type%TYPE := '';

2192: l_match_option VARCHAR2(1);
2193: l_currency_code RCV_TRANSACTIONS.currency_code%TYPE;
2194: l_currency_conversion_rate NUMBER;
2195: l_currency_conversion_date DATE;
2196: l_currency_conversion_type RCV_TRANSACTIONS.currency_conversion_type%TYPE := '';
2197: l_sob_id NUMBER;
2198: l_po_line_location_id NUMBER;
2199: l_rcv_transaction_id NUMBER;
2200:

Line 2276: FROM rcv_transactions RT

2272: RT.currency_conversion_date
2273: INTO l_currency_conversion_rate,
2274: l_currency_conversion_type,
2275: l_currency_conversion_date
2276: FROM rcv_transactions RT
2277: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id;
2278:
2279: END IF;
2280: ELSE

Line 2469: l_trx_type rcv_transactions.transaction_type%TYPE;

2465: l_overlaid_acct NUMBER;
2466: /* Support for Landed Cost Management */
2467: l_lcm_acct_id NUMBER;
2468:
2469: l_trx_type rcv_transactions.transaction_type%TYPE;
2470: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
2471: l_parent_trx_id NUMBER;
2472: l_account_flag NUMBER := 0;
2473: BEGIN

Line 2470: l_parent_trx_type rcv_transactions.transaction_type%TYPE;

2466: /* Support for Landed Cost Management */
2467: l_lcm_acct_id NUMBER;
2468:
2469: l_trx_type rcv_transactions.transaction_type%TYPE;
2470: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
2471: l_parent_trx_id NUMBER;
2472: l_account_flag NUMBER := 0;
2473: BEGIN
2474: -- Standard start of API savepoint

Line 2573: FROM rcv_transactions TRX,

2569:
2570: l_stmt_num := 40;
2571: SELECT PARENT_TRX.transaction_type
2572: INTO l_parent_trx_type
2573: FROM rcv_transactions TRX,
2574: rcv_transactions PARENT_TRX
2575: WHERE TRX.transaction_id = p_rcv_event.rcv_transaction_id
2576: AND TRX.parent_transaction_id = PARENT_TRX.transaction_id;
2577: END IF;

Line 2574: rcv_transactions PARENT_TRX

2570: l_stmt_num := 40;
2571: SELECT PARENT_TRX.transaction_type
2572: INTO l_parent_trx_type
2573: FROM rcv_transactions TRX,
2574: rcv_transactions PARENT_TRX
2575: WHERE TRX.transaction_id = p_rcv_event.rcv_transaction_id
2576: AND TRX.parent_transaction_id = PARENT_TRX.transaction_id;
2577: END IF;
2578:

Line 2831: FROM rcv_transactions RT

2827:
2828: l_stmt_num := 140;
2829: SELECT RT.transaction_type, RT.parent_transaction_id
2830: INTO l_trx_type, l_parent_trx_id
2831: FROM rcv_transactions RT
2832: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id;
2833:
2834: IF(l_trx_type = 'DELIVER')THEN
2835: l_credit_acct_id := l_pod_budget_acct_id;

Line 2845: FROM rcv_transactions PARENT_TRX

2841:
2842: l_stmt_num := 150;
2843: SELECT PARENT_TRX.transaction_type
2844: INTO l_parent_trx_type
2845: FROM rcv_transactions PARENT_TRX
2846: WHERE PARENT_TRX.transaction_id = l_parent_trx_id;
2847:
2848: IF(l_parent_trx_type = 'DELIVER')THEN
2849: l_credit_acct_id := l_pod_budget_acct_id;

Line 3764: l_rcv_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;

3760: l_inv_trx_tbl INV_Logical_Transaction_Global.mtl_trx_tbl_type;
3761: l_inv_trx_tbl_ctr BINARY_INTEGER;
3762: l_correct_ind BOOLEAN := FALSE; -- indicator variable for whether these
3763: -- events are for a correction or not
3764: l_rcv_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
3765: l_parent_txn_flag NUMBER := 1;
3766: l_intercompany_price NUMBER; -- may include nr tax depending on the pricing option
3767: l_intercompany_curr_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
3768: l_transfer_organization_id NUMBER := NULL;

Line 3811: FROM rcv_transactions

3807: l_stmt_num := 10;
3808: -- Determine if this group of events are for a CORRECT txn type
3809: SELECT transaction_type
3810: INTO l_rcv_txn_type
3811: FROM rcv_transactions
3812: WHERE transaction_id = p_rcv_events_tbl(l_ctr).rcv_transaction_id;
3813:
3814: if (l_rcv_txn_type = 'CORRECT') then
3815: l_correct_ind := TRUE;

Line 4415: FROM rcv_transactions RT,

4411: l_inv_trx.subinventory_code,
4412: l_inv_trx.locator_id,
4413: l_inv_trx.parent_transaction_flag,
4414: l_inv_trx.trx_source_line_id
4415: FROM rcv_transactions RT,
4416: po_lines POL,
4417: po_line_locations POLL,
4418: po_distributions POD,
4419: fnd_currencies FC