DBA Data[Home] [Help]

APPS.OPI_DBI_JOBS_PKG dependencies on CST_ITEM_COSTS

Line 864: CST_ITEM_COSTS itemcost,

860: WHERE /*fl.status = 2
861: AND */fl.scheduled_start_date >= g_global_start_date
862: ) jobsinner,
863: wip_entities en,
864: CST_ITEM_COSTS itemcost,
865: mfg_lookups ml1
866: WHERE ((en.entity_type in (1,2,3,5,8)
867: AND ml1.lookup_type in ('WIP_JOB_STATUS')) OR
868: (en.entity_type in (4)

Line 1224: CST_ITEM_COSTS itemcost

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
1228: itemcost.cost_type_id in (1,2,5,6) and

Line 1717: cst_item_costs

1713: BEGIN
1714: select
1715: item_cost into x_cost
1716: from
1717: cst_item_costs
1718: where
1719: organization_id = l_organization_id and
1720: inventory_item_id = l_inventory_item_id and
1721: cost_type_id in (1,2,5,6);