DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_TRANSACTION_TYPES

Line 356: FROM mtl_transaction_types mtt

352: mmt.program_id = p_prg_id,
353: mmt.program_update_date = sysdate
354: WHERE NOT EXISTS
355: ( SELECT NULL
356: FROM mtl_transaction_types mtt
357: WHERE mtt.type_class = 1
358: AND mtt.transaction_type_id = mmt.transaction_type_id )
359: AND mmt.organization_id = p_Org_Id
360: AND mmt.transaction_date <= ((trunc(sysdate) - p_prior_days) + 0.99999)

Line 6642: mtl_transaction_types mtt

6638: l_mmt_primary_quantity,
6639: l_txn_type_id,
6640: l_type_class
6641: FROM mtl_material_transactions mmt,
6642: mtl_transaction_types mtt
6643: WHERE mmt.transaction_id = p_transaction_id
6644: AND mtt.transaction_type_id = mmt.transaction_type_id;
6645:
6646: IF l_transaction_action_id <> 17 THEN