DBA Data[Home] [Help]

APPS.OPI_EDW_IDS_CALC dependencies on MTL_SECONDARY_INVENTORIES

Line 1281: FROM mtl_secondary_inventories

1277: AND inventory_item_id = cost_update_item_org.inventory_item_id
1278: AND trx_date = sub_period_end.trx_date
1279: AND subinventory_code NOT IN -- don't update expense sub
1280: (SELECT secondary_inventory_name
1281: FROM mtl_secondary_inventories
1282: WHERE organization_id = p_organization_id
1283: AND asset_inventory <> 1) -- expense sub
1284: AND period_flag = 1 -- just to be safe
1285: AND push_flag = 1; -- just to be safe

Line 1332: FROM mtl_secondary_inventories

1328: WHERE organization_id = p_organization_id
1329: AND inventory_item_id = cost_update_item_org.inventory_item_id
1330: AND subinventory_code NOT IN -- don't update expense sub
1331: (SELECT secondary_inventory_name
1332: FROM mtl_secondary_inventories
1333: WHERE organization_id = p_organization_id
1334: AND asset_inventory <> 1) -- expense sub
1335: AND trx_date = next_period_start
1336: AND period_flag = 0 -- just to be safe