DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 312: FROM mtl_material_transactions_temp

308:
309: BEGIN
310: SELECT COUNT(transaction_temp_id)
311: INTO trx_found
312: FROM mtl_material_transactions_temp
313: WHERE organization_id = org_id
314: AND subinventory_code = NVL(sub_code, subinventory_code)
315: AND NVL(locator_id,-9999) = NVL(loc_id, NVL(locator_id,-9999)) ;
316:

Line 856: mtl_material_transactions_temp or the

852:
853: This procedure provides the project and task from
854: po_req_distributions_all via po_requisition_lines_all table
855: for the requisition_line_id in the
856: mtl_material_transactions_temp or the
857: transaction interface table.
858: */
859: Procedure Get_project_info_from_Req(
860: x_Return_Status Out NOCOPY Varchar2,

Line 895: mtl_material_transactions_temp.

891: populate_project_info procedure.
892:
893: This procedure gets the project and task from po_req_distributions_all
894: via rcv_transactions table for the rcv_transaction_id in the
895: mtl_material_transactions_temp.
896: */
897: Procedure Get_project_info_for_RcvTrx(
898: x_Return_Status Out NOCOPY Varchar2,
899: x_Project_Id Out NOCOPY Number,