DBA Data[Home] [Help]

APPS.CST_EAMJOB_ACTESTIMATE dependencies on BOM_OPERATIONAL_ROUTINGS

Line 407: FROM bom_operational_routings bor,

403: bos.department_id department_id,
404: br.functional_currency_flag functional_currency_flag,
405: br.cost_element_id cost_element_id,
406: br.resource_type resource_type
407: FROM bom_operational_routings bor,
408: bom_operation_resources bomres,
409: bom_operation_sequences bos,
410: bom_resources br,
411: cst_resource_costs crc

Line 424: FROM bom_operational_routings bor1

420: (p_alt_rtg_designator IS NOT NULL)
421: AND (bor.alternate_routing_designator IS NULL)
422: AND NOT EXISTS
423: (SELECT 'X'
424: FROM bom_operational_routings bor1
425: WHERE bor1.assembly_item_id = bor.assembly_item_id
426: AND bor1.organization_id = p_organization_id
427: AND bor1.pending_from_ecn is NULL
428: AND bor1.alternate_routing_designator =

Line 498: bom_operational_routings bor,

494: ) mat_value
495: FROM bom_bill_of_materials bbom,
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

Line 533: FROM bom_operational_routings bor1

529: (p_alt_rtg_designator IS NOT NULL)
530: AND (bor.alternate_routing_designator IS NULL)
531: AND NOT EXISTS
532: (SELECT 'X'
533: FROM bom_operational_routings bor1
534: WHERE bor1.assembly_item_id = bor.assembly_item_id
535: AND bor1.organization_id = p_organization_id
536: AND bor1.pending_from_ecn is NULL
537: AND bor1.alternate_routing_designator =