DBA Data[Home] [Help]

APPS.BOMPLDCI dependencies on MTL_DEMAND

Line 110: FROM mtl_demand

106: rows_processed NUMBER;
107: dupl_cursor NUMBER;
108: CURSOR check_segment IS
109: SELECT distinct organization_id
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,

Line 516: from MTL_DEMAND D,

512: MP.STARTING_REVISION, /* REVISION */
513: l_item_type,
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,

Line 1001: MTL_DEMAND D,

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