eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_MGD_INFL_ADJUSTMENT_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 522: MTL_MATERIAL_TRANSACTIONS

518: NVL(SUM(Primary_Quantity), 0)
519: INTO
520: x_purchase_qty
521: FROM
522: MTL_MATERIAL_TRANSACTIONS
523: WHERE Acct_Period_ID = p_acct_period_id
524: AND Organization_ID = p_org_id
525: AND Inventory_Item_ID = p_inventory_item_id
526: AND Primary_Quantity > 0

Line 531: FROM mtl_material_transactions

527: AND Cost_Group_ID = p_cost_group_id
528: AND Transfer_Organization_ID IS NULL
529: AND nvl(owning_tp_type,2) <> 1
530: AND transaction_id NOT IN (SELECT transaction_id
531: FROM mtl_material_transactions
532: WHERE acct_period_id = p_acct_period_id
533: AND organization_id = p_org_id
534: AND inventory_item_id = p_inventory_item_id
535: AND transaction_source_type_id = 13

Line 538: FROM mtl_material_transactions

534: AND inventory_item_id = p_inventory_item_id
535: AND transaction_source_type_id = 13
536: AND transaction_action_id = 24)
537: AND transaction_id NOT IN (SELECT transaction_id
538: FROM mtl_material_transactions
539: WHERE acct_period_id = p_acct_period_id
540: AND organization_id = p_org_id
541: AND inventory_item_id = p_inventory_item_id
542: AND transaction_source_type_id = 13

Line 593: MTL_MATERIAL_TRANSACTIONS

589: NVL(SUM(Primary_Quantity), 0)
590: INTO
591: x_issue_qty
592: FROM
593: MTL_MATERIAL_TRANSACTIONS
594: WHERE Acct_Period_ID = p_acct_period_id
595: AND Organization_ID = p_org_id
596: AND Inventory_Item_ID = p_inventory_item_id
597: AND Primary_Quantity < 0

Line 602: FROM mtl_material_transactions

598: AND Cost_Group_ID = p_cost_group_id
599: AND Transfer_Organization_ID IS NULL
600: AND nvl(owning_tp_type,2) <> 1
601: AND transaction_id NOT IN (SELECT transaction_id
602: FROM mtl_material_transactions
603: WHERE acct_period_id = p_acct_period_id
604: AND organization_id = p_org_id
605: AND inventory_item_id = p_inventory_item_id
606: AND transaction_source_type_id = 13

Line 927: MTL_MATERIAL_TRANSACTIONS MTL

923: , MTL.Transfer_Organization_ID
924: , NVL(Primary_Quantity, 0) Transfer_In_Qty
925: , ORG.Acct_Period_ID TNSF_Acct_Period_ID
926: FROM
927: MTL_MATERIAL_TRANSACTIONS MTL
928: , ORG_ACCT_PERIODS ORG
929: WHERE MTL.Organization_ID = p_inflation_adjustment_rec.organization_id
930: AND MTL.Inventory_Item_ID = p_inflation_adjustment_rec.inventory_item_id
931: AND MTL.Acct_Period_ID = p_inflation_adjustment_rec.acct_period_id

Line 956: MTL_MATERIAL_TRANSACTIONS

952: Transaction_ID
953: , Transfer_Organization_ID
954: , NVL(Primary_Quantity, 0) Transfer_Out_Qty
955: FROM
956: MTL_MATERIAL_TRANSACTIONS
957: WHERE Organization_ID = p_inflation_adjustment_rec.organization_id
958: AND Inventory_Item_ID = p_inflation_adjustment_rec.inventory_item_id
959: AND Acct_Period_ID = p_inflation_adjustment_rec.acct_period_id
960: AND Primary_Quantity < 0