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

Line 62: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;

58: l_err_code VARCHAR2(240);
59: l_err_msg VARCHAR2(240);
60: l_return_code NUMBER;
61:
62: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
63: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
64: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 63: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;

59: l_err_msg VARCHAR2(240);
60: l_return_code NUMBER;
61:
62: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
63: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
64: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
67: l_grparent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;

Line 64: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

60: l_return_code NUMBER;
61:
62: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
63: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
64: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
67: l_grparent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
68: l_grparent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;

61:
62: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
63: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
64: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
67: l_grparent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
68: l_grparent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
69: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

Line 66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;

62: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
63: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
64: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
67: l_grparent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
68: l_grparent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
69: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
70:

Line 67: l_grparent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;

63: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
64: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
67: l_grparent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
68: l_grparent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
69: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
70:
71: -- 12i Complex Work Procurement -------------------------------------------

Line 68: l_grparent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;

64: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
67: l_grparent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
68: l_grparent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
69: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
70:
71: -- 12i Complex Work Procurement -------------------------------------------
72: l_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

Line 153: FROM rcv_transactions RT

149: l_transaction_type,
150: l_parent_trx_id,
151: l_po_header_id,
152: l_po_line_location_id --12i Complex Work Procurement
153: FROM rcv_transactions RT
154: WHERE transaction_id = p_rcv_transaction_id;
155:
156: -- If receiving transaction is for a REQ, or an RMA, we do not
157: -- do not do any accounting.

Line 171: FROM rcv_transactions

167: l_stmt_num := 60;
168: -- Get Parent Transaction Type
169: SELECT transaction_type, parent_transaction_id
170: INTO l_parent_trx_type, l_grparent_trx_id
171: FROM rcv_transactions
172: WHERE transaction_id = l_parent_trx_id;
173:
174: IF(l_grparent_trx_id NOT IN (0,-1)) THEN
175: l_stmt_num := 70;

Line 179: FROM rcv_transactions

175: l_stmt_num := 70;
176: -- Get Grand Parent Transaction Type
177: SELECT transaction_type
178: INTO l_grparent_trx_type
179: FROM rcv_transactions
180: WHERE transaction_id = l_grparent_trx_id;
181: END IF;
182: END IF;
183:

Line 424: FROM rcv_transactions

420: -- for a given po_header or po_release
421:
422: CURSOR c_parent_receive_txns_csr IS
423: SELECT transaction_id, organization_id
424: FROM rcv_transactions
425: WHERE ( ( transaction_type = 'RECEIVE'
426: and parent_transaction_id = -1 )
427: or
428: transaction_type = 'MATCH' )

Line 439: FROM rcv_transactions

435: -- a parent receive transaction.
436:
437: CURSOR c_deliver_txns_csr (l_par_txn IN NUMBER) IS
438: SELECT transaction_id, po_distribution_id
439: FROM rcv_transactions
440: WHERE transaction_type = 'DELIVER'
441: START WITH transaction_id = l_par_txn
442: CONNECT BY parent_transaction_id = prior transaction_id;
443:

Line 452: rcv_transactions RT

448: CURSOR c_po_dists_csr (l_rcv_txn IN NUMBER) IS
449: SELECT POD.po_distribution_id
450: FROM po_distributions POD,
451: po_line_locations POLL,
452: rcv_transactions RT
453: WHERE POD.line_location_id = POLL.line_location_id
454: AND POLL.line_location_id = RT.po_line_location_id
455: AND RT.transaction_id = l_rcv_txn;
456:

Line 565: -- RAE for a particular Receive transaction in RCV_TRANSACTIONS

561:
562: IF l_rae_count > 0 THEN
563:
564: -- Rownum check is there since there might be multiple events in
565: -- RAE for a particular Receive transaction in RCV_TRANSACTIONS
566:
567: l_stmt_num := 60;
568:
569: SELECT RAE.organization_id, RAE.trx_flow_header_id, NVL(RT.dropship_type_code,3)

Line 572: rcv_transactions RT

568:
569: SELECT RAE.organization_id, RAE.trx_flow_header_id, NVL(RT.dropship_type_code,3)
570: INTO l_organization_id, l_trx_flow_header_id,l_drop_ship_flag
571: FROM rcv_accounting_events RAE,
572: rcv_transactions RT
573: WHERE RAE.rcv_transaction_id = c_par_txn.transaction_id
574: AND RT.transaction_id = RAE.rcv_transaction_id
575: AND RAE.procurement_org_flag = 'Y'
576: AND rownum = 1;

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

579: END IF;
580:
581:
582: -- One event is seeded per PO distribution
583: -- If RCV_TRANSACTIONS has the po_distribution_id populated, we
584: -- use that. Otherwise, we use cursor c_po_dists_csr to seed as many events
585: -- as the number of distributions for the line_location
586:
587: l_stmt_num := 70;

Line 591: FROM rcv_transactions

587: l_stmt_num := 70;
588:
589: SELECT nvl(po_distribution_id, -1)
590: INTO l_po_distribution_id
591: FROM rcv_transactions
592: WHERE transaction_id = c_par_txn.transaction_id;
593:
594:
595: IF l_po_distribution_id <> -1 THEN

Line 1150: rcv_transactions RT

1146: l_lcm_flag
1147: FROM po_headers POH,
1148: po_line_locations POLL,
1149: po_lines POL,
1150: rcv_transactions RT
1151: WHERE RT.transaction_id = p_rcv_transaction_id
1152: AND POH.po_header_id = RT.po_header_id
1153: AND POLL.line_location_id = RT.po_line_location_id
1154: AND POL.po_line_id = RT.po_line_id;

Line 1544: FROM rcv_Transactions RT

1540: l_stmt_num := 130;
1541: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
1542: RCV_SeedEvents_PVT.RECEIVE)
1543: INTO l_event_type_id
1544: FROM rcv_Transactions RT
1545: WHERE transaction_id = p_rcv_transaction_id;
1546:
1547: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1548: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

Line 1841: rcv_transactions RT

1837: FROM po_headers POH,
1838: po_line_locations POLL,
1839: po_lines POL,
1840: po_distributions POD,
1841: rcv_transactions RT
1842: WHERE RT.transaction_id = p_rcv_transaction_id
1843: AND POH.po_header_id = RT.po_header_id
1844: AND POLL.line_location_id = RT.po_line_location_id
1845: AND POL.po_line_id = RT.po_line_id

Line 2033: FROM rcv_Transactions RT

2029: l_stmt_num := 50;
2030: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
2031: RCV_SeedEvents_PVT.DELIVER)
2032: INTO l_event_type_id
2033: FROM rcv_Transactions RT
2034: WHERE transaction_id = p_rcv_transaction_id;
2035:
2036: l_stmt_num := 60;
2037: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2387: rcv_transactions RT

2383: FROM po_headers POH,
2384: po_line_locations POLL,
2385: po_lines POL,
2386: po_distributions POD,
2387: rcv_transactions RT
2388: WHERE RT.transaction_id = p_rcv_transaction_id
2389: AND POH.po_header_id = RT.po_header_id
2390: AND POLL.line_location_id = RT.po_line_location_id
2391: AND POL.po_line_id = RT.po_line_id

Line 2571: FROM rcv_Transactions RT

2567: l_stmt_num := 50;
2568: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
2569: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING)
2570: INTO l_event_type_id
2571: FROM rcv_Transactions RT
2572: WHERE transaction_id = p_rcv_transaction_id;
2573:
2574: l_stmt_num := 60;
2575: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2941: rcv_transactions RT

2937: l_lcm_flag
2938: FROM po_headers POH,
2939: po_line_locations POLL,
2940: po_lines POL,
2941: rcv_transactions RT
2942: WHERE RT.transaction_id = p_rcv_transaction_id
2943: AND POH.po_header_id = RT.po_header_id
2944: AND POLL.line_location_id = RT.po_line_location_id
2945: AND POL.po_line_id = RT.po_line_id;

Line 3277: FROM rcv_Transactions RT

3273: l_stmt_num := 110;
3274: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
3275: RCV_SeedEvents_PVT.RETURN_TO_VENDOR)
3276: INTO l_event_type_id
3277: FROM rcv_Transactions RT
3278: WHERE transaction_id = p_rcv_transaction_id;
3279:
3280: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3281: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

Line 3500: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;

3496: l_stmt_num NUMBER := 0;
3497: l_api_message VARCHAR2(1000);
3498:
3499: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
3500: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
3501: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
3502: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3503: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
3504: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 3501: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;

3497: l_api_message VARCHAR2(1000);
3498:
3499: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
3500: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
3501: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
3502: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3503: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
3504: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
3505: l_po_header_id NUMBER;

Line 3502: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

3498:
3499: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
3500: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
3501: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
3502: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3503: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
3504: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
3505: l_po_header_id NUMBER;
3506: l_po_distribution_id NUMBER;

Line 3503: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;

3499: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
3500: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
3501: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
3502: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3503: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
3504: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
3505: l_po_header_id NUMBER;
3506: l_po_distribution_id NUMBER;
3507: l_po_line_id NUMBER;

Line 3504: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;

3500: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
3501: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
3502: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3503: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
3504: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
3505: l_po_header_id NUMBER;
3506: l_po_distribution_id NUMBER;
3507: l_po_line_id NUMBER;
3508: l_po_line_location_id NUMBER;

Line 3623: rcv_transactions RT

3619: FROM po_headers POH,
3620: po_line_locations POLL,
3621: po_lines POL,
3622: po_distributions POD,
3623: rcv_transactions RT
3624: WHERE RT.transaction_id = p_rcv_transaction_id
3625: AND POH.po_header_id = RT.po_header_id
3626: AND POLL.line_location_id = RT.po_line_location_id
3627: AND POL.po_line_id = RT.po_line_id

Line 3641: FROM rcv_transactions PARENT

3637: IF(l_transaction_type = 'CORRECT') THEN
3638: l_stmt_num := 20;
3639: SELECT transaction_type
3640: INTO l_parent_trx_type
3641: FROM rcv_transactions PARENT
3642: WHERE PARENT.transaction_id = l_parent_trx_id;
3643: END IF;
3644:
3645: -- This API is only applicable for Deliver/RTR transactions or corrections to deliver/RTR