APPS.OE_CONFIG_VALIDATION_PVT dependencies on BOM_EXPLOSIONS

Line 114: the date for effective/diabled filter on bom_explosions sqls.

110:
111: ER2625376: changes made to BOM should be visible to Order unitl Booking.
112:
113: OE_Config_Util.Get_Config_effective_Date should be used to decide
114: the date for effective/diabled filter on bom_explosions sqls.
115:
116: p_creatione_date parameter will be renamed to p_effective_date.
117: ------------------------------------------------------------------------*/
118:

Line 525: it selects the min and max quantity from bom_explosions table. Some or all

521: /*-----------------------------------------------------------------------
522: PROCEDURE: Check_Min_Max
523: This procedure loops through the options table.
524: For each option,
525: it selects the min and max quantity from bom_explosions table. Some or all
526: of the options might not have the min max range set up in the BOM set up.
527: if the ordered quantity is not within the range, it popuplates a message
528: and it sets the return staus to error.
529: If all the options are within the min max range, we return success.

Line 572: FROM bom_explosions be1

568: ELSE
569:
570: SELECT nvl(be1.high_quantity,0), nvl(be1.low_quantity,0)
571: INTO l_max_allowed_qty, l_min_allowed_qty
572: FROM bom_explosions be1
573: WHERE be1.TOP_BILL_SEQUENCE_ID = p_top_bill_sequence_id
574: AND be1.component_code = p_options_tbl(I).component_code
575: AND be1.effectivity_date <=
576: p_effective_date

Line 796: FROM BOM_EXPLOSIONS BOMEXP

792: l_valid_config VARCHAR2(10) := 'TRUE';
793:
794: CURSOR MUTUALLY_EXCLUSIVE_OPTIONS IS
795: SELECT bomexp.description, bomexp.component_code
796: FROM BOM_EXPLOSIONS BOMEXP
797: WHERE bomexp.explosion_type = 'OPTIONAL'
798: AND bomexp.top_bill_sequence_id = p_top_bill_sequence_id
799: AND bomexp.plan_level >= 0
800: AND bomexp.effectivity_date <=

Line 955: FROM bom_explosions bomexp

951:
952: CURSOR MANDATORY_COMPONENTS IS
953: SELECT bomexp.description, bomexp.component_code
954: --,bomexp.sort_order???? perf
955: FROM bom_explosions bomexp
956: WHERE bomexp.explosion_type = 'OPTIONAL'
957: AND bomexp.top_bill_sequence_id = p_top_bill_sequence_id
958: AND bomexp.plan_level >= 0
959: AND bomexp.effectivity_date <=

Line 970: , BOM_EXPLOSIONS BOMEXP

966: /*
967: CURSOR MANDATORY_COMPONENTS IS
968: SELECT bomexp.description, bomexp.component_code
969: FROM OE_ORDER_LINES OECFG
970: , BOM_EXPLOSIONS BOMEXP
971: WHERE OECFG.TOP_MODEL_LINE_ID = p_top_model_line_id
972: AND OECFG.SERVICE_REFERENCE_LINE_ID IS NULL
973: AND OECFG.ITEM_TYPE_CODE IN ( 'MODEL', 'CLASS' )
974: AND BOMEXP.EXPLOSION_TYPE = 'OPTIONAL'