DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_TRANSACTION_TYPES

Line 355: FROM mtl_transaction_types mtt

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

Line 6505: mtl_transaction_types mtt

6501: l_mmt_primary_quantity,
6502: l_txn_type_id,
6503: l_type_class
6504: FROM mtl_material_transactions mmt,
6505: mtl_transaction_types mtt
6506: WHERE mmt.transaction_id = p_transaction_id
6507: AND mtt.transaction_type_id = mmt.transaction_type_id;
6508:
6509: IF l_transaction_action_id <> 17 THEN