[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
7531: AND (NVL (MSC_ATP_PVT.G_ORG_INFO_REC.org_type,MSC_ATP_PVT.DISCRETE_ORG) = MSC_ATP_PVT.DISCRETE_ORG) THEN --Bug-4694958
7532: BEGIN
7533: SELECT BOMS.ASSEMBLY_QUANTITY
7534: INTO l_assembly_quantity
7535: FROM MSC_BOMS BOMS
7536: WHERE BOMS.PLAN_ID = p_plan_id
7537: AND BOMS.SR_INSTANCE_ID = p_instance_id
7538: AND BOMS.ORGANIZATION_ID = p_organization_id
7539: AND BOMS.BILL_SEQUENCE_ID = p_bill_seq_id;
9370: FROM MSC_SYSTEM_ITEMS I2,
9371: MSC_CALENDAR_DATES C2,
9372: MSC_CALENDAR_DATES C1,
9373: MSC_BOM_COMPONENTS MBC,
9374: MSC_BOMS BOMS,
9375: MSC_SYSTEM_ITEMS I,
9376: MSC_OPERATION_COMPONENTS OPC,
9377: MSC_ROUTING_OPERATIONS OP
9378: WHERE I.PLAN_ID = BOMS.PLAN_ID
9384: AND BOMS.ORGANIZATION_ID = p_organization_id
9385: AND BOMS.BILL_SEQUENCE_ID = l_bill_seq_id --(3004862) circular BOM issue: use cursor parameter
9386: --(ssurendr) Bug 2865389 Removed condition for Alternate bom designator as
9387: --we are accessing bom by bill sequance id.
9388: --We can now drive by msc_boms for performance gains
9389: --AND BOMS.ALTERNATE_BOM_DESIGNATOR IS NULL
9390: AND MBC.USAGE_QUANTITY > 0
9391: AND MBC.BILL_SEQUENCE_ID = BOMS.BILL_SEQUENCE_ID
9392: AND MBC.PLAN_ID = I.PLAN_ID
9517: FROM MSC_SYSTEM_ITEMS I2,
9518: MSC_CALENDAR_DATES C2,
9519: MSC_CALENDAR_DATES C1,
9520: MSC_BOM_COMPONENTS MBC,
9521: MSC_BOMS BOMS
9522: WHERE BOMS.PLAN_ID = p_plan_id
9523: AND BOMS.SR_INSTANCE_ID = p_instance_id
9524: AND BOMS.ORGANIZATION_ID = p_organization_id
9525: AND BOMS.BILL_SEQUENCE_ID = l_bill_seq_id --(3004862) circular BOM issue: use cursor parameter