APPS.BOM_OPRESOURCE_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 29: From bom_operational_routings

25: cursor l_assy_csr(P_RtgSeqId number) is
26: Select assembly_item_id,
27: organization_id,
28: alternate_routing_designator
29: From bom_operational_routings
30: Where routing_sequence_id = P_RtgSeqId;
31: cursor l_parameter_csr(P_Code varchar2) is
32: Select organization_id
33: From mtl_parameters

Line 38: from bom_operational_routings

34: Where organization_code = P_Code;
35: cursor l_routing_csr(P_AssyItemId number, P_OrgId number,
36: P_Alternate varchar2) is
37: select routing_sequence_id
38: from bom_operational_routings
39: where organization_id = P_OrgId
40: and assembly_item_id = P_AssyItemId
41: and nvl(alternate_routing_designator, 'Primary Alternate') =
42: nvl(P_Alternate, 'Primary Alternate');

Line 371: bom_operational_routings bor

367: Where not exists(
368: select null
369: from cst_activities ca,
370: bom_operation_sequences bos,
371: bom_operational_routings bor
372: where ca.activity_id = P_ActivityId
373: and bos.operation_sequence_id = P_OpSeqId
374: and bos.routing_sequence_id =
375: bor.routing_sequence_id