DBA Data[Home] [Help]

APPS.OPI_DBI_JOBS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 877: mtl_system_items_b msi

873: itemcost.cost_type_id in (1,2,5,6) and
874: itemcost.organization_id = en.organization_id and
875: itemcost.inventory_item_id = en.primary_item_id
876: ) jobs,
877: mtl_system_items_b msi
878: WHERE msi.inventory_item_id = jobs.assembly_item_id
879: AND msi.organization_id = jobs.organization_id;
880:
881: l_row_count := sql%rowcount;

Line 1223: MTL_SYSTEM_ITEMS_B MSI,

1219: EN.ENTITY_TYPE = 4 AND -- Flow Schedules
1220: ML1.LOOKUP_TYPE = 'WIP_FLOW_SCHEDULE_STATUS' AND ML1.LOOKUP_CODE = FL.STATUS AND
1221: FL.SCHEDULED_START_DATE >= g_global_start_date
1222: ) JOBS,
1223: MTL_SYSTEM_ITEMS_B MSI,
1224: CST_ITEM_COSTS itemcost
1225: WHERE
1226: MSI.INVENTORY_ITEM_ID = JOBS.Assembly_Item_id AND
1227: MSI.ORGANIZATION_ID = JOBS.ORGANIZATION_ID AND