APPS.BOMPLDCI dependencies on FND_ID_FLEX_SEGMENTS

Line 115: FND_ID_FLEX_SEGMENTS FS,

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'
119: and FS.ID_FLEX_NUM = 101

Line 521: FND_ID_FLEX_SEGMENTS FS,

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,
523: MTL_PARAMETERS MP
524: where D.config_group_id = USERENV('SESSIONID')
525: and D.ORGANIZATION_ID = S.ORGANIZATION_ID

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 1002: FND_ID_FLEX_SEGMENTS FS,

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
1004: where I2.ORGANIZATION_ID = S.ORGANIZATION_ID
1005: and I2.BASE_ITEM_ID = S.INVENTORY_ITEM_ID
1006: and P.ORGANIZATION_ID = I2.ORGANIZATION_ID