DBA Data[Home] [Help]

APPS.FLM_SUPPLY_DEMAND dependencies on MTL_SYSTEM_ITEMS

Line 365: MTL_SYSTEM_ITEMS I,

361: BOM_CALENDAR_DATES C,
362: MTL_PARAMETERS P,
363: MTL_ONHAND_QUANTITIES Q,
364: MTL_ATP_RULES R,
365: MTL_SYSTEM_ITEMS I,
366: MTL_GROUP_ITEM_ATPS_VIEW V
367: WHERE I.ORGANIZATION_ID = V.ORGANIZATION_ID
368: AND I.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
369: AND Q.ORGANIZATION_ID = V.ORGANIZATION_ID

Line 400: MTL_SYSTEM_ITEMS I,

396: FROM MTL_SECONDARY_INVENTORIES S,
397: BOM_CALENDAR_DATES C,
398: MTL_PARAMETERS P,
399: MTL_MATERIAL_TRANSACTIONS_TEMP T,
400: MTL_SYSTEM_ITEMS I,
401: MTL_ATP_RULES R,
402: MTL_GROUP_ITEM_ATPS_VIEW V
403: WHERE I.ORGANIZATION_ID = V.ORGANIZATION_ID
404: AND I.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID

Line 474: MTL_SYSTEM_ITEMS I,

470: V.ORGANIZATION_ID organization_id
471: FROM
472: BOM_CALENDAR_DATES C,
473: MTL_USER_SUPPLY U,
474: MTL_SYSTEM_ITEMS I,
475: MTL_PARAMETERS P,
476: MTL_ATP_RULES R,
477: MTL_GROUP_ITEM_ATPS_VIEW V
478: WHERE U.ORGANIZATION_ID = V.ORGANIZATION_ID

Line 583: MTL_SYSTEM_ITEMS I,

579: V.ORGANIZATION_ID organization_id
580: FROM
581: MTL_GROUP_ITEM_ATPS_VIEW V,
582: MTL_ATP_RULES R,
583: MTL_SYSTEM_ITEMS I,
584: MTL_PARAMETERS P,
585: BOM_CALENDAR_DATES C,
586: MTL_SUPPLY S
587: WHERE V.ATP_GROUP_ID = P_GROUP_ID

Line 690: MTL_SYSTEM_ITEMS I,

686: V.ORGANIZATION_ID organization_id
687: FROM WIP_DISCRETE_JOBS D,
688: BOM_CALENDAR_DATES C,
689: MTL_PARAMETERS P,
690: MTL_SYSTEM_ITEMS I,
691: MTL_ATP_RULES R,
692: MTL_GROUP_ITEM_ATPS_VIEW V
693: WHERE D.STATUS_TYPE IN (1,3,4,6)
694: AND (D.START_QUANTITY-D.QUANTITY_COMPLETED-D.QUANTITY_SCRAPPED) >0

Line 778: MTL_SYSTEM_ITEMS I,

774: V.ORGANIZATION_ID organization_id
775: FROM MTL_GROUP_ITEM_ATPS_VIEW V,
776: MTL_PARAMETERS P,
777: MTL_ATP_RULES R,
778: MTL_SYSTEM_ITEMS I,
779: BOM_CALENDAR_DATES C,
780: WIP_REQUIREMENT_OPERATIONS O,
781: WIP_DISCRETE_JOBS D
782: WHERE O.ORGANIZATION_ID=D.ORGANIZATION_ID

Line 873: MTL_SYSTEM_ITEMS I,

869: V.ORGANIZATION_ID organization_id
870: FROM
871: MTL_GROUP_ATPS_VIEW V,
872: MTL_ATP_RULES R,
873: MTL_SYSTEM_ITEMS I,
874: MTL_PARAMETERS P,
875: BOM_CALENDAR_DATES C,
876: BOM_CALENDAR_DATES C1,
877: WIP_REPETITIVE_SCHEDULES WRS,

Line 970: MTL_SYSTEM_ITEMS I,

966: FROM
967: WIP_FLOW_SCHEDULES D,
968: BOM_CALENDAR_DATES C,
969: MTL_PARAMETERS P,
970: MTL_SYSTEM_ITEMS I,
971: MTL_ATP_RULES R,
972: MTL_GROUP_ITEM_ATPS_VIEW V
973: WHERE D.STATUS = 1
974: AND (D.PLANNED_QUANTITY-D.QUANTITY_COMPLETED) >0

Line 1057: MTL_SYSTEM_ITEMS I,

1053: FROM
1054: MTL_GROUP_ITEM_ATPS_VIEW V,
1055: MTL_PARAMETERS P,
1056: MTL_ATP_RULES R,
1057: MTL_SYSTEM_ITEMS I,
1058: BOM_CALENDAR_DATES C,
1059: WIP_REQUIREMENT_OPERATIONS O,
1060: WIP_DISCRETE_JOBS D,
1061: BOM_CALENDAR_DATES C1

Line 1156: MTL_SYSTEM_ITEMS I,

1152: FROM
1153: MTL_GROUP_ITEM_ATPS_VIEW V,
1154: MTL_PARAMETERS P,
1155: MTL_ATP_RULES R,
1156: MTL_SYSTEM_ITEMS I,
1157: BOM_CALENDAR_DATES C,
1158: BOM_CALENDAR_DATES C1,
1159: WIP_REPETITIVE_SCHEDULES WRS,
1160: WIP_OPERATIONS WO,

Line 1258: MTL_SYSTEM_ITEMS I,

1254: FROM
1255: MTL_GROUP_ITEM_ATPS_VIEW V,
1256: MTL_PARAMETERS P,
1257: MTL_ATP_RULES R,
1258: MTL_SYSTEM_ITEMS I,
1259: MTL_USER_DEMAND U,
1260: BOM_CALENDAR_DATES C
1261: WHERE U.ORGANIZATION_ID = V.ORGANIZATION_ID
1262: AND U.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID

Line 1342: MTL_SYSTEM_ITEMS I,

1338: BOM_BILL_OF_MATERIALS BOM ,
1339: BOM_EXPLOSIONS BE ,
1340: BOM_CALENDAR_DATES C,
1341: MTL_PARAMETERS P,
1342: MTL_SYSTEM_ITEMS I,
1343: MTL_ATP_RULES R,
1344: MTL_GROUP_ITEM_ATPS_VIEW V
1345: WHERE V.AVAILABLE_TO_ATP = 1
1346: AND V.ATP_RULE_ID = R.RULE_ID

Line 1455: MTL_SYSTEM_ITEMS I,

1451: V.ORGANIZATION_ID organization_id
1452: FROM
1453: MTL_GROUP_ITEM_ATPS_VIEW V,
1454: MTL_PARAMETERS P,
1455: MTL_SYSTEM_ITEMS I,
1456: MTL_ATP_RULES R,
1457: BOM_CALENDAR_DATES C,
1458: MTL_DEMAND D,
1459: BOM_CALENDAR_DATES C1

Line 1546: MTL_SYSTEM_ITEMS I

1542: MTL_ATP_RULES R ,
1543: /* MTL_GROUP_ATPS_VIEW G , */
1544: MTL_DEMAND_INTERFACE G, /* use the table directly - perf bug 4899603 */
1545: MTL_PARAMETERS P ,
1546: MTL_SYSTEM_ITEMS I
1547: WHERE I.ATP_FLAG in ('C', 'Y')
1548: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
1549: AND G.ATP_GROUP_ID = p_group_id
1550: AND G.ORGANIZATION_ID = I.ORGANIZATION_ID