APPS.RCV_ACCRUALUTILITIES_GRP dependencies on RCV_ACCOUNTING_EVENTS

Line 369: FROM rcv_accounting_events RAE

365: l_stmt_num := 60;
366:
367: SELECT count(*)
368: INTO l_rae_count
369: FROM rcv_accounting_events RAE
370: WHERE RAE.rcv_transaction_id = rec_txn.transaction_id
371: AND RAE.organization_id = rec_txn.organization_id
372: AND RAE.event_type_id IN (1,2,3,4,5,6)
373: AND RAE.TRX_FLOW_HEADER_ID IS NOT NULL;

Line 496: from RCV_ACCOUNTING_EVENTS RAE

492: l_stmt_num := 92 ;
493: select nvl(sum((RAE.unit_price-RAE.prior_unit_price) * nvl(RAE.currency_conversion_rate,1)*
494: RAE.source_doc_quantity/RAE.primary_quantity * RAE.source_doc_quantity),0)
495: into l_retro_rae_price
496: from RCV_ACCOUNTING_EVENTS RAE
497: WHERE RAE.rcv_transaction_id = rec_txn.transaction_id
498: AND RAE.organization_id = rec_txn.organization_id
499: AND RAE.event_type_id IN (7,8)
500: AND ((p_valuation_date is not null

Line 511: FROM rcv_accounting_events RAE

507: RAE.source_doc_quantity/RAE.primary_quantity * RAE.source_doc_quantity)
508: )
509: )
510: INTO l_rae_count,l_txn_price
511: FROM rcv_accounting_events RAE
512: WHERE RAE.rcv_transaction_id = rec_txn.transaction_id
513: AND RAE.organization_id = rec_txn.organization_id
514: AND RAE.event_type_id IN (1,2,3,4,5,6)
515: AND ((p_valuation_date is not null

Line 676: FROM rcv_accounting_events RAE

672: SELECT sum(decode(RAE.primary_quantity, 0, 0,
673: (RAE.unit_price * nvl(RAE.currency_conversion_rate,1)*
674: RAE.source_doc_quantity/RAE.primary_quantity * RAE.source_doc_quantity)))
675: INTO l_txn_price
676: FROM rcv_accounting_events RAE
677: WHERE RAE.rcv_transaction_id = rec_txn.transaction_id
678: AND RAE.organization_id = rec_txn.organization_id
679: AND RAE.event_type_id IN (1,2,3,4,5,6);
680:

Line 730: FROM rcv_accounting_events rae

726: 15,rae.primary_quantity,
727: -1*rae.primary_quantity)*
728: (rae.unit_price-rae.prior_unit_price)),0)
729: INTO l_rae_price
730: FROM rcv_accounting_events rae
731: WHERE rae.event_type_id IN (15,16,17)
732: AND rae.rcv_transaction_id = l_rcv_transaction_id
733: AND((p_valuation_date is not null
734: and rae.transaction_date <= p_valuation_date)

Line 1051: DELETE FROM RCV_ACCOUNTING_EVENTS

1047: BEGIN
1048: l_stmt_num := 30;
1049:
1050: FORALL l_index in p_purge_in_rec.entity_ids.FIRST..p_purge_in_rec.entity_ids.LAST
1051: DELETE FROM RCV_ACCOUNTING_EVENTS
1052: WHERE RCV_TRANSACTION_ID = p_purge_in_rec.entity_ids(l_index);
1053: FORALL l_index in p_purge_in_rec.entity_ids.FIRST..p_purge_in_rec.entity_ids.LAST
1054: DELETE FROM RCV_RECEIVING_SUB_LEDGER
1055: WHERE RCV_TRANSACTION_ID = p_purge_in_rec.entity_ids(l_index);

Line 1088: p_error_text => 'Purge of RCV_Accounting_Events/RCV_Receiving_Sub_Ledger Failed'||

1084: IF G_MSG_LEVEL_THRESHOLD <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH THEN
1085: FND_MSG_PUB.Add_Exc_Msg(
1086: p_pkg_name => G_PKG_NAME,
1087: p_procedure_name => l_api_name,
1088: p_error_text => 'Purge of RCV_Accounting_Events/RCV_Receiving_Sub_Ledger Failed'||
1089: to_char(l_stmt_num) || ' '||
1090: SQLERRM
1091: );
1092: