APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 780: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,

776: CURSOR Txn_Error_Cur(p_txn_Id NUMBER) IS
777: SELECT intf.ERROR_EXPLANATION ,intf.ERROR_CODE, kfv.concatenated_segments,
778: WO.workorder_name
779: --FROM MTL_MATERIAL_TRANSACTIONS_TEMP
780: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,
781: ahl_workorders WO
782: --WHERE TRANSACTION_TEMP_ID = p_txn_Id;
783: WHERE TRANSACTION_INTERFACE_ID = p_txn_Id
784: AND intf.inventory_item_id = kfv.inventory_item_id

Line 3791: INSERT INTO MTL_TRANSACTIONS_INTERFACE

3787: ||to_char(p_x_txn_hdr_id)||','
3788: ||to_char(p_x_txn_intf_id)||']');
3789: END IF;
3790:
3791: INSERT INTO MTL_TRANSACTIONS_INTERFACE
3792:
3793: ( TRANSACTION_INTERFACE_ID , TRANSACTION_HEADER_ID ,
3794: SOURCE_CODE , SOURCE_LINE_ID ,
3795: SOURCE_HEADER_ID, PROCESS_FLAG ,

Line 5467: x_row MTL_TRANSACTIONS_INTERFACE%rowtype;

5463:
5464: /*
5465: PROCEDURE SHOW_MTX_ERRORS
5466: AS
5467: x_row MTL_TRANSACTIONS_INTERFACE%rowtype;
5468: CURSOR CL
5469: IS
5470: select * into x_row
5471: from MTL_TRANSACTIONS_INTERFACE;

Line 5471: from MTL_TRANSACTIONS_INTERFACE;

5467: x_row MTL_TRANSACTIONS_INTERFACE%rowtype;
5468: CURSOR CL
5469: IS
5470: select * into x_row
5471: from MTL_TRANSACTIONS_INTERFACE;
5472: begin
5473: return;
5474: FOR CLREC IN CL
5475: LOOP