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.

[Home] [Help]

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 1395: FROM rcv_transactions RT, mtl_units_of_measure MUOM

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

Line 1484: FROM rcv_transactions

1480: /* Support for Landed Cost Management */
1481: IF (p_rcv_event.event_source = 'RECEIVING' AND p_lcm_flag = 'Y') THEN
1482: SELECT unit_landed_cost
1483: INTO x_unit_landed_cost
1484: FROM rcv_transactions
1485: WHERE transaction_id = p_rcv_event.rcv_transaction_id;
1486:
1487: END IF;
1488:

Line 2134: -- rcv_transactions.curr_conv_rate--

2130: -- --
2131: -- Logic: --
2132: -- If supplier facing org, if match to po use POD.rate --
2133: -- else --
2134: -- rcv_transactions.curr_conv_rate--
2135: -- Else --
2136: -- Get the conversion type --
2137: -- Determine currency conversion rate --
2138: -- --

Line 2186: l_currency_code RCV_TRANSACTIONS.currency_code%TYPE;

2182: l_api_message VARCHAR2(1000);
2183:
2184: -- local data variables
2185: l_match_option VARCHAR2(1);
2186: l_currency_code RCV_TRANSACTIONS.currency_code%TYPE;
2187: l_currency_conversion_rate NUMBER;
2188: l_currency_conversion_date DATE;
2189: l_currency_conversion_type RCV_TRANSACTIONS.currency_conversion_type%TYPE := '';
2190: l_sob_id NUMBER;

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

2185: l_match_option VARCHAR2(1);
2186: l_currency_code RCV_TRANSACTIONS.currency_code%TYPE;
2187: l_currency_conversion_rate NUMBER;
2188: l_currency_conversion_date DATE;
2189: l_currency_conversion_type RCV_TRANSACTIONS.currency_conversion_type%TYPE := '';
2190: l_sob_id NUMBER;
2191: l_po_line_location_id NUMBER;
2192: l_rcv_transaction_id NUMBER;
2193:

Line 2269: FROM rcv_transactions RT

2265: RT.currency_conversion_date
2266: INTO l_currency_conversion_rate,
2267: l_currency_conversion_type,
2268: l_currency_conversion_date
2269: FROM rcv_transactions RT
2270: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id;
2271:
2272: END IF;
2273: ELSE

Line 2462: l_trx_type rcv_transactions.transaction_type%TYPE;

2458: l_overlaid_acct NUMBER;
2459: /* Support for Landed Cost Management */
2460: l_lcm_acct_id NUMBER;
2461:
2462: l_trx_type rcv_transactions.transaction_type%TYPE;
2463: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
2464: l_parent_trx_id NUMBER;
2465: l_account_flag NUMBER := 0;
2466: BEGIN

Line 2463: l_parent_trx_type rcv_transactions.transaction_type%TYPE;

2459: /* Support for Landed Cost Management */
2460: l_lcm_acct_id NUMBER;
2461:
2462: l_trx_type rcv_transactions.transaction_type%TYPE;
2463: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
2464: l_parent_trx_id NUMBER;
2465: l_account_flag NUMBER := 0;
2466: BEGIN
2467: -- Standard start of API savepoint

Line 2566: FROM rcv_transactions TRX,

2562:
2563: l_stmt_num := 40;
2564: SELECT PARENT_TRX.transaction_type
2565: INTO l_parent_trx_type
2566: FROM rcv_transactions TRX,
2567: rcv_transactions PARENT_TRX
2568: WHERE TRX.transaction_id = p_rcv_event.rcv_transaction_id
2569: AND TRX.parent_transaction_id = PARENT_TRX.transaction_id;
2570: END IF;

Line 2567: rcv_transactions PARENT_TRX

2563: l_stmt_num := 40;
2564: SELECT PARENT_TRX.transaction_type
2565: INTO l_parent_trx_type
2566: FROM rcv_transactions TRX,
2567: rcv_transactions PARENT_TRX
2568: WHERE TRX.transaction_id = p_rcv_event.rcv_transaction_id
2569: AND TRX.parent_transaction_id = PARENT_TRX.transaction_id;
2570: END IF;
2571:

Line 2822: FROM rcv_transactions RT

2818:
2819: l_stmt_num := 140;
2820: SELECT RT.transaction_type, RT.parent_transaction_id
2821: INTO l_trx_type, l_parent_trx_id
2822: FROM rcv_transactions RT
2823: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id;
2824:
2825: IF(l_trx_type = 'DELIVER')THEN
2826: l_credit_acct_id := l_pod_budget_acct_id;

Line 2836: FROM rcv_transactions PARENT_TRX

2832:
2833: l_stmt_num := 150;
2834: SELECT PARENT_TRX.transaction_type
2835: INTO l_parent_trx_type
2836: FROM rcv_transactions PARENT_TRX
2837: WHERE PARENT_TRX.transaction_id = l_parent_trx_id;
2838:
2839: IF(l_parent_trx_type = 'DELIVER')THEN
2840: l_credit_acct_id := l_pod_budget_acct_id;

Line 3755: l_rcv_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;

3751: l_inv_trx_tbl INV_Logical_Transaction_Global.mtl_trx_tbl_type;
3752: l_inv_trx_tbl_ctr BINARY_INTEGER;
3753: l_correct_ind BOOLEAN := FALSE; -- indicator variable for whether these
3754: -- events are for a correction or not
3755: l_rcv_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
3756: l_parent_txn_flag NUMBER := 1;
3757: l_intercompany_price NUMBER; -- may include nr tax depending on the pricing option
3758: l_intercompany_curr_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
3759: l_transfer_organization_id NUMBER := NULL;

Line 3802: FROM rcv_transactions

3798: l_stmt_num := 10;
3799: -- Determine if this group of events are for a CORRECT txn type
3800: SELECT transaction_type
3801: INTO l_rcv_txn_type
3802: FROM rcv_transactions
3803: WHERE transaction_id = p_rcv_events_tbl(l_ctr).rcv_transaction_id;
3804:
3805: if (l_rcv_txn_type = 'CORRECT') then
3806: l_correct_ind := TRUE;

Line 4406: FROM rcv_transactions RT,

4402: l_inv_trx.subinventory_code,
4403: l_inv_trx.locator_id,
4404: l_inv_trx.parent_transaction_flag,
4405: l_inv_trx.trx_source_line_id
4406: FROM rcv_transactions RT,
4407: po_lines POL,
4408: po_line_locations POLL,
4409: po_distributions POD,
4410: fnd_currencies FC