DBA Data[Home] [Help]

APPS.CST_PERIODIC_AVERAGE_PROC_CP dependencies on MTL_TRANSACTION_TYPES

Line 777: , mtl_transaction_types mtt

773: , mmt.organization_id
774: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
775: , mmt.subinventory_code
776: FROM mtl_material_transactions mmt
777: , mtl_transaction_types mtt
778: WHERE mmt.transaction_date between p_start_date
779: AND p_end_date
780: AND mmt.transaction_action_id = 24
781: AND mmt.transaction_source_type_id = 14

Line 799: , mtl_transaction_types mtt

795: , mmt.organization_id
796: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
797: , mmt.subinventory_code
798: FROM mtl_material_transactions mmt
799: , mtl_transaction_types mtt
800: WHERE mmt.transaction_date between p_start_date
801: AND p_end_date
802: AND mmt.transaction_action_id = 24
803: AND mmt.transaction_source_type_id = 14