APPS.CST_MGD_MSTR_BOOK_RPT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 631: MTL_MATERIAL_TRANSACTIONS mmt

627: , mmt.Transfer_Organization_ID Transfer_Organization_ID
628: , mmt.Creation_date Creation_date
629: , mmt.quantity_adjusted
630: FROM
631: MTL_MATERIAL_TRANSACTIONS mmt
632: WHERE mmt.Organization_ID = p_org_id
633: AND mmt.Inventory_Item_ID = p_item_id
634: AND NVL(mmt.Acct_Period_ID,0) = NVL(p_acct_period_id,NVL(mmt.ACCT_PERIOD_ID,0))
635: AND NVL(mmt.Subinventory_code,'0') >= NVL(p_subinv_from,NVL(mmt.Subinventory_code,'0'))

Line 652: MTL_MATERIAL_TRANSACTIONS mmt1

648: )
649: AND mmt.transaction_id NOT IN
650: (SELECT mmt1.transaction_id
651: FROM
652: MTL_MATERIAL_TRANSACTIONS mmt1
653: WHERE mmt1.organization_id = p_org_id
654: AND mmt1.inventory_item_id = p_item_id
655: AND NVL(mmt1.Acct_Period_ID,0) = NVL(p_acct_period_id,NVL(mmt1.ACCT_PERIOD_ID,0))
656: AND NVL(mmt1.Subinventory_code,'0') >= NVL(p_subinv_from,NVL(mmt1.Subinventory_code,'0'))

Line 1070: , MTL_MATERIAL_TRANSACTIONS MTX ';

1066:
1067: v_from_clause := ' FROM MTL_SYSTEM_ITEMS_KFV MSI
1068: , gl_sets_of_books gsob
1069: , org_organization_definitions ood
1070: , MTL_MATERIAL_TRANSACTIONS MTX ';
1071:
1072: v_where_clause := ' WHERE MSI.Organization_ID=:org_id
1073: AND ood.organization_id = MSI.Organization_id
1074: AND ood.set_of_books_id = gsob.set_of_books_id

Line 1269: FROM MTL_MATERIAL_TRANSACTIONS mmt

1265: -- owning_tp_type will be 1 for consigned transaction
1266: -- bug#3118846 fix: exclude TRX from NON Qty tracked subinventories
1267: SELECT NVL(SUM(mmt.Primary_Quantity), 0)
1268: INTO l_item_trx_qty
1269: FROM MTL_MATERIAL_TRANSACTIONS mmt
1270: WHERE mmt.ORGANIZATION_ID = p_org_id
1271: AND mmt.INVENTORY_ITEM_ID = l_item_id
1272: AND mmt.SUBINVENTORY_CODE BETWEEN nvl(p_subinv_from, mmt.subinventory_code)
1273: AND nvl(p_subinv_to,mmt.subinventory_code)

Line 1286: FROM MTL_MATERIAL_TRANSACTIONS mmt1

1282: AND ASSET_INVENTORY = 1 )
1283: )
1284: AND mmt.transaction_id NOT IN
1285: (SELECT mmt1.transaction_id
1286: FROM MTL_MATERIAL_TRANSACTIONS mmt1
1287: WHERE mmt1.organization_id = p_org_id
1288: AND mmt1.inventory_item_id = l_item_id
1289: AND mmt1.SUBINVENTORY_CODE
1290: BETWEEN nvl(p_subinv_from, mmt1.subinventory_code)

Line 1320: FROM MTL_MATERIAL_TRANSACTIONS mmt

1316: begin
1317: -- Bug#2576310 fix subinventory code to add in the WHERE condition
1318: Select NVL(mmt.PRIOR_COST,mmt.ACTUAL_COST)
1319: INTO l_item_unit_cost
1320: FROM MTL_MATERIAL_TRANSACTIONS mmt
1321: WHERE mmt.TRANSACTION_ID = (SELECT min(transaction_id)
1322: From Mtl_Material_Transactions
1323: Where Organization_Id = p_org_id
1324: And Inventory_Item_Id = l_item_id

Line 1322: From Mtl_Material_Transactions

1318: Select NVL(mmt.PRIOR_COST,mmt.ACTUAL_COST)
1319: INTO l_item_unit_cost
1320: FROM MTL_MATERIAL_TRANSACTIONS mmt
1321: WHERE mmt.TRANSACTION_ID = (SELECT min(transaction_id)
1322: From Mtl_Material_Transactions
1323: Where Organization_Id = p_org_id
1324: And Inventory_Item_Id = l_item_id
1325: And Transaction_date =
1326: (Select min(Transaction_date)

Line 1327: From Mtl_Material_Transactions

1323: Where Organization_Id = p_org_id
1324: And Inventory_Item_Id = l_item_id
1325: And Transaction_date =
1326: (Select min(Transaction_date)
1327: From Mtl_Material_Transactions
1328: Where Organization_Id = p_org_id
1329: And Transaction_action_id NOT IN (24,30)
1330: AND nvl(owning_tp_type, 2) <> 1
1331: And Transaction_date between l_rpt_from_date and l_rpt_to_date

Line 1347: FROM MTL_MATERIAL_TRANSACTIONS mmt1

1343: AND ASSET_INVENTORY = 1 )
1344: )
1345: AND mmt.transaction_id NOT IN
1346: (SELECT mmt1.transaction_id
1347: FROM MTL_MATERIAL_TRANSACTIONS mmt1
1348: WHERE mmt1.organization_id = p_org_id
1349: AND mmt1.inventory_item_id = l_item_id
1350: AND nvl(mmt1.owning_tp_type,2) = 1
1351: AND mmt1.transaction_date