DBA Data[Home] [Help]

APPS.BOMPCCLT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 397: Bom_Operational_Routings bor

393: AND COM.EFFECTIVITY_DATE <= p_eff_date));
394: Cursor Get_OLTP (P_Assembly number, P_Org_Id number, P_Operation number) is
395: Select nvl(bos.operation_lead_time_percent, 0) operation_lead_time_percent
396: From Bom_Operation_Sequences bos,
397: Bom_Operational_Routings bor
398: Where bor.assembly_item_id = P_Assembly
399: And bor.organization_Id = P_Org_Id
400: And bor.alternate_routing_designator is null
401: And bor.common_routing_sequence_id = bos.routing_sequence_id