DBA Data[Home] [Help]

APPS.CST_EAMJOB_ACTESTIMATE dependencies on MTL_SYSTEM_ITEMS

Line 500: mtl_system_items_b msi,

496: bom_inventory_components bic,
497: cst_cg_item_costs_view ccicv,
498: bom_operational_routings bor,
499: bom_operation_sequences bos,
500: mtl_system_items_b msi,
501: wip_eam_parameters wep
502: WHERE bbom.organization_id = p_organization_id
503: AND bbom.assembly_item_id = p_activity_item_id
504: AND bbom.assembly_type = 1

Line 616: FROM mtl_system_items msi

612: l_stmt_num := 10;
613:
614: SELECT NVL(eam_item_type,-1)
615: INTO l_eam_item_type
616: FROM mtl_system_items msi
617: WHERE msi.organization_id = p_organization_id
618: AND msi.inventory_item_id = p_activity_item_id;
619:
620: IF l_eam_item_type <> 2 THEN