APPS.BOMPLDCI dependencies on BOM_PARAMETERS

Line 114: from BOM_PARAMETERS P,

110: FROM mtl_demand
111: WHERE config_group_id = USERENV('SESSIONID');
112: CURSOR fnd_check(l_org_id NUMBER) IS
113: select nvl(FV.MAXIMUM_SIZE,-99)
114: from BOM_PARAMETERS P,
115: FND_ID_FLEX_SEGMENTS FS,
116: FND_FLEX_VALUE_SETS FV
117: where P.ORGANIZATION_ID = l_org_id
118: and FS.ID_FLEX_CODE = 'MSTK'

Line 162: ** Check to see if the config_segment_name exists in bom_parameters

158: ci_del := '';
159: end if;
160:
161: /*
162: ** Check to see if the config_segment_name exists in bom_parameters
163: ** for the given organizations
164: */
165: table_name := 'BOM_PARAMETERS';
166: stmt_num :=15;

Line 165: table_name := 'BOM_PARAMETERS';

161: /*
162: ** Check to see if the config_segment_name exists in bom_parameters
163: ** for the given organizations
164: */
165: table_name := 'BOM_PARAMETERS';
166: stmt_num :=15;
167:
168: IF org_id = -1 THEN
169: stmt_num := 16;

Line 177: from bom_parameters

173: FETCH check_segment INTO org_buf;
174: EXIT WHEN check_segment%NOTFOUND;
175: stmt_num := 18;
176: select config_segment_name into dummy_name
177: from bom_parameters
178: where organization_id = org_buf;
179: IF dummy_name is NULL THEN RAISE segment_name_error;
180: END IF;
181: OPEN fnd_check(org_buf);

Line 196: from bom_parameters

192: CLOSE check_segment;
193: ELSE
194: stmt_num := 19;
195: select config_segment_name into dummy_name
196: from bom_parameters
197: where organization_id = org_id;
198: IF dummy_name is NULL THEN RAISE segment_name_error;
199: END IF;
200: OPEN fnd_check(org_id);

Line 518: BOM_PARAMETERS P,

514: 'N',
515: 'N'
516: from MTL_DEMAND D,
517: MTL_SYSTEM_ITEMS S,
518: BOM_PARAMETERS P,
519: MTL_SALES_ORDERS L,
520: SO_LINES_ALL SL,
521: FND_ID_FLEX_SEGMENTS FS,
522: FND_FLEX_VALUE_SETS FV,

Line 573: from fnd_id_flex_segments fs, bom_parameters p

569: END IF;
570:
571: stmt_num := 23;
572: select application_column_name into dummy_name
573: from fnd_id_flex_segments fs, bom_parameters p
574: where p.organization_id = org_buf
575: and fs.id_flex_code = 'MSTK'
576: and fs.id_flex_num = 101
577: and fs.segment_name = p.config_segment_name

Line 771: from bom_parameters

767: dbms_sql.column_value(dupl_cursor,2,o_id);
768: /* ATOPUTIL.info('Duplicate Item:' || inv_id ||', Org_id:'|| o_id ); */
769:
770: select config_number_method_type into org_method
771: from bom_parameters
772: where organization_id = org_buf;
773:
774: stmt_num := 102;
775: if org_method = 4 THEN RAISE dupl_error;

Line 999: BOM_PARAMETERS P,

995: L.SEGMENT1|| ci_del || D.USER_LINE_NUM ||ci_del|| D.USER_DELIVERY || ci_del ||
996: TO_CHAR(hold_next_seq)), S.SEGMENT20),S.SEGMENT20)
997: from MTL_SYSTEM_ITEMS_INTERFACE I2,
998: MTL_SYSTEM_ITEMS S,
999: BOM_PARAMETERS P,
1000: MTL_SALES_ORDERS L,
1001: MTL_DEMAND D,
1002: FND_ID_FLEX_SEGMENTS FS,
1003: FND_FLEX_VALUE_SETS FV