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 204: FROM rcv_transactions RT

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

Line 252: FROM rcv_transactions rt,

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

Line 310: FROM rcv_transactions RT

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

Line 353: FROM rcv_transactions RT, rcv_transactions PARENT

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

Line 406: FROM po_distributions_all POD, rcv_transactions RT

402: l_stmt_num := 70;
403:
404: SELECT POD.destination_type_code
405: INTO l_destination_type_code
406: FROM po_distributions_all POD, rcv_transactions RT
407: WHERE POD.po_distribution_id = RT.po_distribution_id
408: AND RT.transaction_id = rec_txn.transaction_id;
409:
410: IF l_sLog THEN

Line 573: FROM RCV_TRANSACTIONS

569: IF (l_wcti_count = 0) then /*prior patchset j */
570: l_stmt_num := 100;
571: SELECT DECODE (PO_DISTRIBUTION_ID, NULL, 0, 1)
572: INTO l_dist_flag
573: FROM RCV_TRANSACTIONS
574: WHERE TRANSACTION_ID = rec_txn.transaction_id;
575:
576: IF l_sLog THEN
577: l_api_message := 'l_dist_flag : '||l_dist_flag;

Line 595: FROM rcv_transactions RT,

591: 'R',NVL(RT.currency_conversion_rate,1),
592: 'P',NVL(NVL(POD.rate,POH.rate),1)) *
593: (RT.source_doc_quantity/RT.primary_quantity)))
594: INTO l_txn_price
595: FROM rcv_transactions RT,
596: po_distributions_all POD,
597: po_line_locations_all PLL,
598: po_headers_all POH
599: WHERE RT.transaction_id = rec_txn.transaction_id

Line 619: rcv_transactions rt

615: l_tax
616: from
617: po_distributions_all pod,
618: po_line_locations_all pol,
619: rcv_transactions rt
620: where
621: rt.transaction_id = rec_txn.transaction_id
622: and rt.po_line_location_id = pol.line_location_id
623: and pod.line_location_id = pol.line_location_id;

Line 642: FROM rcv_transactions RT,

638: 'R',NVL(RT.currency_conversion_rate, 1),
639: 'P',NVL(POH.rate, 1)) *
640: (RT.source_doc_quantity/RT.primary_quantity)))
641: INTO l_txn_price
642: FROM rcv_transactions RT,
643: po_line_locations_all PLL,
644: po_headers_all POH
645: WHERE RT.transaction_id = rec_txn.transaction_id
646: AND PLL.line_location_id = RT.po_line_location_id

Line 760: FROM rcv_transactions RT,

756: l_stmt_num := 160;
757:
758: SELECT PARENT.transaction_type
759: INTO l_parent_txn_type
760: FROM rcv_transactions RT,
761: rcv_transactions PARENT
762: WHERE RT.transaction_id = rec_txn.transaction_id
763: AND PARENT.transaction_id = RT.parent_transaction_id;
764:

Line 761: rcv_transactions PARENT

757:
758: SELECT PARENT.transaction_type
759: INTO l_parent_txn_type
760: FROM rcv_transactions RT,
761: rcv_transactions PARENT
762: WHERE RT.transaction_id = rec_txn.transaction_id
763: AND PARENT.transaction_id = RT.parent_transaction_id;
764:
765: IF l_sLog THEN

Line 895: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS

891: -- Pre-reqs :
892: -- Parameters :
893: -- p_purge_entity_type IN VARCHAR2
894: -- The table of which the entity is the primary identifier
895: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
896: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
897: -- Contains the List of PO_HEADER_ID's to be evaluated
898: -- x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype
899: -- Contains c character ('Y'/'N') indicating whether records

Line 989: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS

985: -- Pre-reqs :
986: -- Parameters :
987: -- p_purge_entity_type IN VARCHAR2
988: -- The table of which the entity is the primary identifier
989: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
990: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
991: -- Contains the List of PO_HEADER_ID's for which corresponding
992: -- records need to be deleted from RAE and RRS
993: ----------------------------------------------------------------------------------------------

Line 1043: IF p_purge_entity_type <> 'RCV_TRANSACTIONS' THEN

1039: x_return_status := FND_API.G_RET_STS_SUCCESS;
1040:
1041: l_stmt_num := 25;
1042:
1043: IF p_purge_entity_type <> 'RCV_TRANSACTIONS' THEN
1044: RAISE INCORRECT_ENTITY;
1045: END IF;
1046:
1047: BEGIN

Line 1188: rcv_transactions rt

1184: select sum(nvl(mta.base_transaction_value, 0))
1185: into l_encReversalAmt
1186: from mtl_material_transactions mmt,
1187: mtl_transaction_accounts mta,
1188: rcv_transactions rt
1189: where rt.po_distribution_id = p_po_distribution_id
1190: and fnd_date.date_to_canonical(rt.transaction_date)
1191: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1192: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))

Line 1203: rcv_transactions rt

1199: l_stmt_num := 50;
1200: select sum(nvl(rrs.accounted_dr,0)-nvl(rrs.accounted_cr,0))
1201: into l_encReversalAmt
1202: from rcv_receiving_sub_ledger rrs,
1203: rcv_transactions rt
1204: where rt.po_distribution_id = p_po_distribution_id
1205: and fnd_date.date_to_canonical(rt.transaction_date)
1206: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1207: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))