DBA Data[Home] [Help]

APPS.BOMPLDCI dependencies on FND_FLEX_VALUE_SETS

Line 116: FND_FLEX_VALUE_SETS FV

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
120: and FS.SEGMENT_NAME = P.CONFIG_SEGMENT_NAME

Line 522: FND_FLEX_VALUE_SETS FV,

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
526: and D.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID

Line 1003: FND_FLEX_VALUE_SETS FV

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
1007: and D.DEMAND_SOURCE_LINE = I2.DEMAND_SOURCE_LINE