DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 307: FROM mtl_material_transactions_temp

303:
304: BEGIN
305: SELECT COUNT(transaction_temp_id)
306: INTO trx_found
307: FROM mtl_material_transactions_temp
308: WHERE organization_id = org_id
309: AND subinventory_code = NVL(sub_code, subinventory_code)
310: AND NVL(locator_id,-9999) = NVL(loc_id, NVL(locator_id,-9999)) ;
311:

Line 851: mtl_material_transactions_temp or the

847:
848: This procedure provides the project and task from
849: po_req_distributions_all via po_requisition_lines_all table
850: for the requisition_line_id in the
851: mtl_material_transactions_temp or the
852: transaction interface table.
853: */
854: Procedure Get_project_info_from_Req(
855: x_Return_Status Out NOCOPY Varchar2,

Line 890: mtl_material_transactions_temp.

886: populate_project_info procedure.
887:
888: This procedure gets the project and task from po_req_distributions_all
889: via rcv_transactions table for the rcv_transaction_id in the
890: mtl_material_transactions_temp.
891: */
892: Procedure Get_project_info_for_RcvTrx(
893: x_Return_Status Out NOCOPY Varchar2,
894: x_Project_Id Out NOCOPY Number,