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_ACCRUALUTILITIES_GRP dependencies on RCV_TRANSACTIONS

Line 171: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;

167:
168: l_total_price NUMBER;
169: l_total_quantity NUMBER;
170: l_rae_count NUMBER;
171: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
172: l_source_doc_code RCV_TRANSACTIONS.SOURCE_DOCUMENT_CODE%TYPE;
173:
174: l_rcv_organization_id RCV_TRANSACTIONS.organization_id%TYPE;
175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;

Line 172: l_source_doc_code RCV_TRANSACTIONS.SOURCE_DOCUMENT_CODE%TYPE;

168: l_total_price NUMBER;
169: l_total_quantity NUMBER;
170: l_rae_count NUMBER;
171: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
172: l_source_doc_code RCV_TRANSACTIONS.SOURCE_DOCUMENT_CODE%TYPE;
173:
174: l_rcv_organization_id RCV_TRANSACTIONS.organization_id%TYPE;
175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;
176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 174: l_rcv_organization_id RCV_TRANSACTIONS.organization_id%TYPE;

170: l_rae_count NUMBER;
171: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
172: l_source_doc_code RCV_TRANSACTIONS.SOURCE_DOCUMENT_CODE%TYPE;
173:
174: l_rcv_organization_id RCV_TRANSACTIONS.organization_id%TYPE;
175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;
176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;
177: l_po_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
178: l_rcv_org_id CST_ORGANIZATION_DEFINITIONS.operating_unit%TYPE;

Line 175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;

171: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
172: l_source_doc_code RCV_TRANSACTIONS.SOURCE_DOCUMENT_CODE%TYPE;
173:
174: l_rcv_organization_id RCV_TRANSACTIONS.organization_id%TYPE;
175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;
176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;
177: l_po_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
178: l_rcv_org_id CST_ORGANIZATION_DEFINITIONS.operating_unit%TYPE;
179: l_rcv_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;

Line 201: FROM rcv_transactions RT

197: RT.source_doc_quantity source_doc_quantity,
198: RT.organization_id organization_id,
199: RT.primary_quantity primary_quantity,
200: nvl(RT.unit_landed_cost,0) unit_landed_cost
201: FROM rcv_transactions RT
202: WHERE ((c_valuation_date is not null and transaction_date <= c_valuation_date)
203: OR c_valuation_date is null)
204: START WITH transaction_id = c_transaction_id
205: CONNECT BY parent_transaction_id = PRIOR transaction_id;

Line 249: FROM rcv_transactions rt,

245: SELECT rt.source_document_code, rt.po_header_id, rt.organization_id,
246: nvl(poll.lcm_flag,'N')
247: INTO l_source_doc_code, l_po_header_id, l_rcv_organization_id,
248: l_lcm_flag
249: FROM rcv_transactions rt,
250: po_line_locations_all poll
251: WHERE rt.transaction_id = p_rcv_transaction_id
252: AND rt.po_line_location_id = poll.line_location_id;
253:

Line 307: FROM rcv_transactions RT

303: FROM (
304: SELECT RT.transaction_id transaction_id,
305: RT.parent_transaction_id parent_transaction_id,
306: RT.transaction_type
307: FROM rcv_transactions RT
308: START WITH transaction_id = p_rcv_transaction_id
309: CONNECT BY transaction_id = PRIOR parent_transaction_id)
310: WHERE ((transaction_type = 'RECEIVE' and parent_transaction_id=-1)
311: OR transaction_type = 'MATCH');

Line 350: FROM rcv_transactions RT, rcv_transactions PARENT

346: l_stmt_num := 50;
347:
348: SELECT PARENT.transaction_type
349: INTO l_parent_txn_type
350: FROM rcv_transactions RT, rcv_transactions PARENT
351: WHERE RT.transaction_id = rec_txn.transaction_id
352: AND PARENT.transaction_id = RT.parent_transaction_id;
353:
354: IF l_sLog THEN

Line 398: FROM po_distributions_all POD, rcv_transactions RT

394: l_stmt_num := 70;
395:
396: SELECT POD.destination_type_code
397: INTO l_destination_type_code
398: FROM po_distributions_all POD, rcv_transactions RT
399: WHERE POD.po_distribution_id = RT.po_distribution_id
400: AND RT.transaction_id = rec_txn.transaction_id;
401:
402: IF l_sLog THEN

Line 471: FROM RCV_TRANSACTIONS

467: /* This is a non-global procurement scenario or a pre-Patchset J transaction */
468: l_stmt_num := 100;
469: SELECT DECODE (PO_DISTRIBUTION_ID, NULL, 0, 1)
470: INTO l_dist_flag
471: FROM RCV_TRANSACTIONS
472: WHERE TRANSACTION_ID = rec_txn.transaction_id;
473:
474: IF l_sLog THEN
475: l_api_message := 'l_dist_flag : '||l_dist_flag;

Line 493: FROM rcv_transactions RT,

489: 'R',NVL(RT.currency_conversion_rate,1),
490: 'P',NVL(NVL(POD.rate,POH.rate),1)) *
491: (RT.source_doc_quantity/RT.primary_quantity)))
492: INTO l_txn_price
493: FROM rcv_transactions RT,
494: po_distributions_all POD,
495: po_line_locations_all PLL,
496: po_headers_all POH
497: WHERE RT.transaction_id = rec_txn.transaction_id

Line 517: rcv_transactions rt

513: l_tax
514: from
515: po_distributions_all pod,
516: po_line_locations_all pol,
517: rcv_transactions rt
518: where
519: rt.transaction_id = rec_txn.transaction_id
520: and rt.po_line_location_id = pol.line_location_id
521: and pod.line_location_id = pol.line_location_id;

Line 540: FROM rcv_transactions RT,

536: 'R',NVL(RT.currency_conversion_rate, 1),
537: 'P',NVL(POH.rate, 1)) *
538: (RT.source_doc_quantity/RT.primary_quantity)))
539: INTO l_txn_price
540: FROM rcv_transactions RT,
541: po_line_locations_all PLL,
542: po_headers_all POH
543: WHERE RT.transaction_id = rec_txn.transaction_id
544: AND PLL.line_location_id = RT.po_line_location_id

Line 655: FROM rcv_transactions RT,

651: l_stmt_num := 160;
652:
653: SELECT PARENT.transaction_type
654: INTO l_parent_txn_type
655: FROM rcv_transactions RT,
656: rcv_transactions PARENT
657: WHERE RT.transaction_id = rec_txn.transaction_id
658: AND PARENT.transaction_id = RT.parent_transaction_id;
659:

Line 656: rcv_transactions PARENT

652:
653: SELECT PARENT.transaction_type
654: INTO l_parent_txn_type
655: FROM rcv_transactions RT,
656: rcv_transactions PARENT
657: WHERE RT.transaction_id = rec_txn.transaction_id
658: AND PARENT.transaction_id = RT.parent_transaction_id;
659:
660: IF l_sLog THEN

Line 790: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS

786: -- Pre-reqs :
787: -- Parameters :
788: -- p_purge_entity_type IN VARCHAR2
789: -- The table of which the entity is the primary identifier
790: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
791: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
792: -- Contains the List of PO_HEADER_ID's to be evaluated
793: -- x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype
794: -- Contains c character ('Y'/'N') indicating whether records

Line 884: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS

880: -- Pre-reqs :
881: -- Parameters :
882: -- p_purge_entity_type IN VARCHAR2
883: -- The table of which the entity is the primary identifier
884: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
885: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
886: -- Contains the List of PO_HEADER_ID's for which corresponding
887: -- records need to be deleted from RAE and RRS
888: ----------------------------------------------------------------------------------------------

Line 938: IF p_purge_entity_type <> 'RCV_TRANSACTIONS' THEN

934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935:
936: l_stmt_num := 25;
937:
938: IF p_purge_entity_type <> 'RCV_TRANSACTIONS' THEN
939: RAISE INCORRECT_ENTITY;
940: END IF;
941:
942: BEGIN

Line 1083: rcv_transactions rt

1079: select sum(nvl(mta.base_transaction_value, 0))
1080: into l_encReversalAmt
1081: from mtl_material_transactions mmt,
1082: mtl_transaction_accounts mta,
1083: rcv_transactions rt
1084: where rt.po_distribution_id = p_po_distribution_id
1085: and fnd_date.date_to_canonical(rt.transaction_date)
1086: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1087: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))

Line 1098: rcv_transactions rt

1094: l_stmt_num := 50;
1095: select sum(nvl(rrs.accounted_dr,0)-nvl(rrs.accounted_cr,0))
1096: into l_encReversalAmt
1097: from rcv_receiving_sub_ledger rrs,
1098: rcv_transactions rt
1099: where rt.po_distribution_id = p_po_distribution_id
1100: and fnd_date.date_to_canonical(rt.transaction_date)
1101: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1102: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))