APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 796: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,

792: CURSOR Txn_Error_Cur(p_txn_Id NUMBER) IS
793: SELECT intf.ERROR_EXPLANATION ,intf.ERROR_CODE, kfv.concatenated_segments,
794: WO.workorder_name
795: --FROM MTL_MATERIAL_TRANSACTIONS_TEMP
796: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,
797: ahl_workorders WO
798: --WHERE TRANSACTION_TEMP_ID = p_txn_Id;
799: WHERE TRANSACTION_INTERFACE_ID = p_txn_Id
800: AND intf.inventory_item_id = kfv.inventory_item_id

Line 811: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,

807: --fix for bug# 13689288
808: CURSOR m_Txn_Error_Cur(p_inventory_item_id IN NUMBER, p_workorder_id IN NUMBER, p_hdr_txn_Id IN NUMBER) IS
809: SELECT intf.ERROR_EXPLANATION, intf.ERROR_CODE, kfv.concatenated_segments,
810: WO.workorder_name
811: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,
812: ahl_workorders WO
813: WHERE TRANSACTION_HEADER_ID = p_hdr_txn_Id
814: AND intf.inventory_item_id = p_inventory_item_id
815: AND wo.workorder_id = p_workorder_id

Line 4507: INSERT INTO MTL_TRANSACTIONS_INTERFACE

4503: ||to_char(p_x_txn_hdr_id)||','
4504: ||to_char(p_x_txn_intf_id)||']');
4505: END IF;
4506:
4507: INSERT INTO MTL_TRANSACTIONS_INTERFACE
4508:
4509: ( TRANSACTION_INTERFACE_ID , TRANSACTION_HEADER_ID ,
4510: SOURCE_CODE , SOURCE_LINE_ID ,
4511: SOURCE_HEADER_ID, PROCESS_FLAG ,

Line 7212: x_row MTL_TRANSACTIONS_INTERFACE%rowtype;

7208:
7209: /*
7210: PROCEDURE SHOW_MTX_ERRORS
7211: AS
7212: x_row MTL_TRANSACTIONS_INTERFACE%rowtype;
7213: CURSOR CL
7214: IS
7215: select * into x_row
7216: from MTL_TRANSACTIONS_INTERFACE;

Line 7216: from MTL_TRANSACTIONS_INTERFACE;

7212: x_row MTL_TRANSACTIONS_INTERFACE%rowtype;
7213: CURSOR CL
7214: IS
7215: select * into x_row
7216: from MTL_TRANSACTIONS_INTERFACE;
7217: begin
7218: return;
7219: FOR CLREC IN CL
7220: LOOP