DBA Data[Home] [Help]

APPS.BOMPCCLT dependencies on BOM_PARAMETERS

Line 18: BOM_PARAMETERS

14: purchased items. Procedure process_items computes cum lead
15: times for a given bom level. Procedure update_lt updates
16: mtl_system_items with cumulative lead time values.
17: Required Tables :
18: BOM_PARAMETERS
19: BOM_INVENTORY_COMPONENTS
20: BOM_BILL_OF_MATERIALS
21: BOM_LOW_LEVEL_CODES
22: MTL_SYSTEM_ITEMS

Line 214: FROM BOM_PARAMETERS

210:
211: l_AbsoluteMaxLevel constant number := 60;
212: cursor l_parameter_csr is
213: SELECT MAXIMUM_BOM_LEVEL
214: FROM BOM_PARAMETERS
215: WHERE ORGANIZATION_ID = org_id;
216: max_bom_level NUMBER;
217: l_stmt_num varchar2(3);
218: cursor l_list_csr is

Line 432: FROM bom_parameters

428:
429:
430: SELECT INCLUDE_MODELS_IN_ROLLUP
431: INTO X_include_models
432: FROM bom_parameters
433: WHERE organization_id = org_id;
434: if(X_include_models ='Y' OR
435: (l_assy_rec.bom_item_type <>1 AND l_assy_rec.bom_item_type <> 2)) THEN
436: X_include_in_rollup :='Y';