APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 116: SELECT APPS.mtl_material_transactions_s.NEXTVAL

112: l_counter_for_validation:=l_counter_for_validation+1;
113: END LOOP;
114:
115: -- Generate an Header id from the sequence
116: SELECT APPS.mtl_material_transactions_s.NEXTVAL
117: INTO l_header_id FROM sys.dual;
118:
119: if (l_slog) then
120: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 749: SELECT mtl_material_transactions_s.nextval

745: END;
746:
747: IF(validAssets_rec.prepare_status='MR') then --Call For Misc Receipt for 7370638
748: --for 7370638
749: SELECT mtl_material_transactions_s.nextval
750: INTO l_transaction_batch_id
751: FROM dual;
752:
753: addAssetsForMiscReceipt(p_header_id,

Line 785: SELECT mtl_material_transactions_s.nextval

781: l_Transaction_UOM:='Ea';
782: --Dbms_Output.put_line('ecxeption occured while selecting');
783: END;
784: -- SELECT INVENTORY_REVISION INTO l_Item_Revision FROM CSI_ITEM_INSTANCES WHERE INVENTORY_ITEM_ID=p_inventory_item_id ;
785: SELECT mtl_material_transactions_s.nextval
786: INTO l_temp_header_id
787: FROM dual;
788: --dbms_output.put_line('l_serial_number_control_code IS'||' '||l_serial_number_control_code);
789: Begin

Line 804: SELECT mtl_material_transactions_s.nextval

800: UPDATE EAM_ASSET_MOVE_TEMP
801: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
802: WHERE CURRENT OF validAssets_cur;
803: IF(l_serial_number_control_code <> 1) THEN
804: SELECT mtl_material_transactions_s.nextval
805: INTO INV_TRANSACTIONS.G_Serial_ID
806: FROM dual;
807: END IF;
808:

Line 1206: SELECT APPS.mtl_material_transactions_s.NEXTVAL

1202: AND ORGANIZATION_ID = l_org_id
1203: AND (SCHEDULE_CLOSE_DATE + 1) > l_sysdate
1204: AND PERIOD_START_DATE <= l_sysdate ;
1205:
1206: SELECT APPS.mtl_material_transactions_s.NEXTVAL
1207: INTO l_txn_if_id
1208: FROM sys.dual;
1209:
1210: INSERT INTO mtl_transactions_interface