APPS.INV_MGD_MVT_FIN_MDTR dependencies on RCV_TRANSACTIONS

Line 1002: rcv_transactions rt

998: CURSOR l_rma IS
999: SELECT
1000: count(transaction_id)
1001: FROM
1002: rcv_transactions rt
1003: , oe_order_lines_all oola
1004: WHERE rt.oe_order_line_id = oola.line_id
1005: AND oola.reference_line_id = to_char(p_movement_transaction.order_line_id)
1006: AND rt.mvt_stat_status = 'PROCESSED'

Line 1020: , RCV_TRANSACTIONS rt

1016: RA_CUSTOMER_TRX_ALL rat
1017: , RA_CUSTOMER_TRX_LINES_ALL ratl
1018: , RA_CUST_TRX_TYPES_ALL ratt
1019: , OE_ORDER_LINES_ALL oola
1020: , RCV_TRANSACTIONS rt
1021: WHERE rat.customer_trx_id = ratl.customer_trx_id
1022: AND rat.cust_trx_type_id = ratt.cust_trx_type_id
1023: AND rat.org_id = ratt.org_id
1024: AND ratt.type IN ('CM','DM')

Line 1050: rcv_transactions

1046: CURSOR l_rtv IS
1047: SELECT
1048: COUNT(transaction_id)
1049: FROM
1050: rcv_transactions
1051: WHERE transaction_type = 'RETURN TO VENDOR'
1052: AND parent_transaction_id = p_movement_transaction.rcv_transaction_id
1053: AND mvt_stat_status = 'PROCESSED';
1054:

Line 1061: rcv_transactions

1057: CURSOR l_total_rtv_quantity IS
1058: SELECT
1059: SUM(quantity)
1060: FROM
1061: rcv_transactions
1062: WHERE po_header_id = p_movement_transaction.po_header_id
1063: AND transaction_type = 'RETURN TO VENDOR';
1064:
1065: --Cursor to get processed rtv transaction quantity exclude

Line 1072: rcv_transactions rt

1068: CURSOR l_netted_rtv_quantity IS
1069: SELECT
1070: SUM(quantity)
1071: FROM
1072: rcv_transactions rt
1073: WHERE po_header_id = p_movement_transaction.po_header_id
1074: AND transaction_type = 'RETURN TO VENDOR'
1075: AND mvt_stat_status = 'PROCESSED'
1076: AND transaction_id NOT IN (SELECT rcv_transaction_id

Line 2606: rcv_transactions

2602: CURSOR l_total_rtv_quantity IS
2603: SELECT
2604: SUM(quantity)
2605: FROM
2606: rcv_transactions
2607: WHERE po_header_id = l_movement_transaction.po_header_id
2608: AND transaction_type = 'RETURN TO VENDOR';
2609:
2610: BEGIN

Line 3448: FROM rcv_transactions

3444: IF l_movement_transaction.rcv_transaction_id IS NOT NULL
3445: THEN
3446: SELECT parent_transaction_id
3447: INTO l_parent_transaction_id
3448: FROM rcv_transactions
3449: WHERE transaction_id = l_movement_transaction.rcv_transaction_id;
3450: END IF;
3451:
3452: EXCEPTION

Line 3925: FROM rcv_transactions

3921: WHERE MMT.transaction_id = x_movement_transaction.mtl_transaction_id;
3922: ELSE
3923: SELECT transaction_date
3924: INTO l_transaction_date
3925: FROM rcv_transactions
3926: WHERE transaction_id = x_movement_transaction.rcv_transaction_id;
3927: END IF;
3928: END IF;
3929: