APPS.CSE_PO_RECEIPT_INTO_PROJECT dependencies on RCV_TRANSACTIONS

Line 72: FROM rcv_transactions

68: BEGIN
69:
70: SELECT interface_transaction_id
71: INTO l_interface_transaction_id
72: FROM rcv_transactions
73: WHERE transaction_id = p_rcv_transaction_id;
74:
75: DELETE FROM mtl_serial_numbers_temp
76: WHERE transaction_temp_id = l_interface_transaction_id;

Line 577: FROM rcv_transactions rt,

573: pla.item_id item_id,
574: pla.item_revision item_revision,
575: to_char(pla.line_num) po_line_number,
576: pha.segment1 po_number
577: FROM rcv_transactions rt,
578: po_distributions_all pda,
579: po_line_locations_all plla,
580: po_lines_all pla,
581: po_headers_all pha

Line 726: UPDATE rcv_transactions

722: 'SET pa_addition_flag = ''Y'''||
723: 'WHERE rcv_transaction_id = :rcv_txn_id ';
724: BEGIN
725: execute immediate l_sql_stmt using p_rcv_transaction_id;
726: UPDATE rcv_transactions
727: SET pa_addition_flag = 'Y'
728: WHERE transaction_id = p_rcv_transaction_id;
729: EXCEPTION
730: WHEN others THEN

Line 731: UPDATE rcv_transactions

727: SET pa_addition_flag = 'Y'
728: WHERE transaction_id = p_rcv_transaction_id;
729: EXCEPTION
730: WHEN others THEN
731: UPDATE rcv_transactions
732: SET pa_addition_flag = 'Y'
733: WHERE transaction_id = p_rcv_transaction_id;
734: END;
735:

Line 910: FROM po_distributions_all pod, rcv_transactions rt

906: debug('rcv_transaction_id: ' || p_rcv_txn_tbl(i).rcv_transaction_id);
907: BEGIN
908: SELECT rt.transaction_date, pod.org_id
909: INTO rt_date, l_org_id
910: FROM po_distributions_all pod, rcv_transactions rt
911: WHERE rt.PO_DISTRIBUTION_ID=pod.po_distribution_id
912: AND rt.transaction_id = p_rcv_txn_tbl(i).rcv_transaction_id;
913:
914: l_gl_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(rt_date, l_org_id);