APPS.CSTPPWAC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1041: mtl_material_transactions mmt

1037: l_stmt_num := 10;
1038: select decode(asset_inventory,1,0,1)
1039: into l_exp1
1040: from mtl_secondary_inventories msi,
1041: mtl_material_transactions mmt
1042: where msi.secondary_inventory_name = mmt.subinventory_code
1043: and msi.organization_id = i_org_id
1044: and mmt.transaction_id = i_txn_id
1045: and mmt.organization_id = i_org_id;

Line 1056: mtl_material_transactions mmt

1052: l_stmt_num := 20;
1053: select decode(asset_inventory,1,0,1)
1054: into l_exp2
1055: from mtl_secondary_inventories msi,
1056: mtl_material_transactions mmt
1057: where msi.secondary_inventory_name = mmt.transfer_subinventory
1058: and msi.organization_id = mmt.transfer_organization_id
1059: and mmt.transaction_id = i_txn_id
1060: and mmt.organization_id = i_org_id;

Line 1290: mtl_material_transactions mmt

1286: else
1287: select decode(asset_inventory,1,0,1)
1288: into l_exp1
1289: from mtl_secondary_inventories msi,
1290: mtl_material_transactions mmt
1291: where msi.secondary_inventory_name = mmt.subinventory_code
1292: and msi.organization_id = i_org_id
1293: and mmt.transaction_id = i_txn_id
1294: and mmt.organization_id = i_org_id;

Line 1645: FROM mtl_material_transactions MMT, WIP_ENTITIES WE

1641: IF (I_TXN_SRC_TYPE_ID = 5) THEN -- checking for eAM jobs
1642:
1643: SELECT decode(WE.entity_type,6,1,7,1,0)
1644: INTO l_eam_job
1645: FROM mtl_material_transactions MMT, WIP_ENTITIES WE
1646: WHERE MMT.transaction_id = i_txn_id
1647: AND MMT.transaction_source_id = WE.wip_entity_id;
1648:
1649: END IF;

Line 1799: from mtl_interorg_parameters mip, mtl_material_transactions mmt

1795:
1796: l_stmt_num := 60;
1797: select nvl(mmt.fob_point, mip.fob_point), mmt.transfer_organization_id
1798: into l_fob_point, l_txfr_org_id
1799: from mtl_interorg_parameters mip, mtl_material_transactions mmt
1800: where mip.from_organization_id = i_org_id
1801: and mip.to_organization_id = mmt.transfer_organization_id
1802: and mmt.transaction_id = i_txn_id;
1803:

Line 3254: UPDATE mtl_material_transactions mmt

3250: * used and this caused errors in the distributions.
3251: * The layer qty can be obtained from cst_pac_quantity_layers
3252: */
3253: l_stmt_num := 120;
3254: UPDATE mtl_material_transactions mmt
3255: SET --primary_quantity = l_onhand,
3256: /* Bug 2288994. Update periodic_primary_quantity also */
3257: periodic_primary_quantity = l_onhand
3258: WHERE mmt.value_change IS NOT NULL