[Home] [Help]
3891: ,comp.rounding_direction rounding_direction
3892: ,comp.component_yield_factor component_yield_factor
3893:
3894: FROM msc_system_items msi, msc_component_substitutes sub,
3895: msc_bom_components comp, msc_boms bom, msc_system_items ch,
3896: msc_system_items pt, mrp_atp_details_temp peg
3897: WHERE peg.session_id = MSC_ATP_PVT.G_SESSION_ID
3898: AND peg.pegging_id = p_parent_pegging_id
3899: AND pt.sr_instance_id = p_instance_id
7535: AND (NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,MSC_ATP_PVT.DISCRETE_ORG) = MSC_ATP_PVT.DISCRETE_ORG) THEN --Bug-4694958
7536: BEGIN
7537: SELECT BOMS.ASSEMBLY_QUANTITY
7538: INTO l_assembly_quantity
7539: FROM MSC_BOMS BOMS
7540: WHERE BOMS.PLAN_ID = p_plan_id
7541: AND BOMS.SR_INSTANCE_ID = p_instance_id
7542: AND BOMS.ORGANIZATION_ID = p_organization_id
7543: AND BOMS.BILL_SEQUENCE_ID = p_bill_seq_id;
9375: FROM MSC_SYSTEM_ITEMS I2,
9376: MSC_CALENDAR_DATES C2,
9377: MSC_CALENDAR_DATES C1,
9378: MSC_BOM_COMPONENTS MBC,
9379: MSC_BOMS BOMS,
9380: MSC_SYSTEM_ITEMS I,
9381: MSC_OPERATION_COMPONENTS OPC,
9382: MSC_ROUTING_OPERATIONS OP
9383: WHERE I.PLAN_ID = BOMS.PLAN_ID
9389: AND BOMS.ORGANIZATION_ID = p_organization_id
9390: AND BOMS.BILL_SEQUENCE_ID = l_bill_seq_id --(3004862) circular BOM issue: use cursor parameter
9391: --(ssurendr) Bug 2865389 Removed condition for Alternate bom designator as
9392: --we are accessing bom by bill sequance id.
9393: --We can now drive by msc_boms for performance gains
9394: --AND BOMS.ALTERNATE_BOM_DESIGNATOR IS NULL
9395: AND MBC.USAGE_QUANTITY > 0
9396: AND MBC.BILL_SEQUENCE_ID = BOMS.BILL_SEQUENCE_ID
9397: AND MBC.PLAN_ID = I.PLAN_ID
9523: FROM MSC_SYSTEM_ITEMS I2,
9524: MSC_CALENDAR_DATES C2,
9525: MSC_CALENDAR_DATES C1,
9526: MSC_BOM_COMPONENTS MBC,
9527: MSC_BOMS BOMS
9528: WHERE BOMS.PLAN_ID = p_plan_id
9529: AND BOMS.SR_INSTANCE_ID = p_instance_id
9530: AND BOMS.ORGANIZATION_ID = p_organization_id
9531: AND BOMS.BILL_SEQUENCE_ID = l_bill_seq_id --(3004862) circular BOM issue: use cursor parameter