APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on MTL_SUPPLY

Line 1063: -- Extract all data from mtl_supply into a temp table.

1059: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1060: l_debug_msg := 'Insert into opi_dbi_intr_sup_tmp. ';
1061: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1062: END IF;
1063: -- Extract all data from mtl_supply into a temp table.
1064: -- Make sure that the primary quantity used is that
1065: -- of the intransit_owning_org.
1066:
1067: -- Bug 4760492

Line 1068: -- MTL supply contains Transaction qty for from/shipping organization.

1064: -- Make sure that the primary quantity used is that
1065: -- of the intransit_owning_org.
1066:
1067: -- Bug 4760492
1068: -- MTL supply contains Transaction qty for from/shipping organization.
1069: -- It might not be same as primary quantity.
1070: -- code has been changed for this
1071: INSERT /*append parallel(opi_dbi_intr_sup_tmp) */
1072: INTO OPI_DBI_INTR_SUP_TMP (

Line 1091: FROM MTL_SUPPLY sup,MTL_SYSTEM_ITEMS msi_fm,mtl_units_of_measure um

1087: NULL,NULL), 0),
1088: NVL(to_org_primary_quantity, 0))) qty,
1089: item_id,
1090: cost_group_id
1091: FROM MTL_SUPPLY sup,MTL_SYSTEM_ITEMS msi_fm,mtl_units_of_measure um
1092: WHERE supply_type_code in ('SHIPMENT' , 'RECEIVING')
1093: AND intransit_owning_org_id IS NOT NULL
1094: AND msi_fm.organization_id = sup.from_organization_id
1095: AND msi_fm.inventory_item_id = sup.item_id

Line 1114: FROM MTL_SUPPLY sup

1110: sup.from_organization_id, NVL(quantity, 0),
1111: NVL(to_org_primary_quantity, 0))) qty,
1112: item_id,
1113: cost_group_id
1114: FROM MTL_SUPPLY sup
1115: WHERE supply_type_code in ('SHIPMENT' , 'RECEIVING')
1116: AND intransit_owning_org_id IS NOT NULL
1117: GROUP BY
1118: intransit_owning_org_id,