[Home] [Help]
358: V.ORGANIZATION_ID organization_id
359: FROM
360: MTL_SECONDARY_INVENTORIES S,
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
394: V.INVENTORY_ITEM_ID inventory_item_id,
395: V.ORGANIZATION_ID organization_id
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
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
479: AND U.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_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
588: AND R.DEMAND_CLASS_ATP_FLAG=2
685: V.INVENTORY_ITEM_ID inventory_item_id,
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)
772: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
773: V.INVENTORY_ITEM_ID inventory_item_id,
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,
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,
878: WIP_REPETITIVE_ITEMS WRI
965: V.ORGANIZATION_ID organization_id
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
1051: V.INVENTORY_ITEM_ID inventory_item_id,
1052: V.ORGANIZATION_ID organization_id
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,
1150: V.INVENTORY_ITEM_ID inventory_item_id,
1151: V.ORGANIZATION_ID organization_id
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,
1252: V.INVENTORY_ITEM_ID inventory_item_id,
1253: V.ORGANIZATION_ID organization_id
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
1337: FROM WIP_FLOW_SCHEDULES F,
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
1450: V.INVENTORY_ITEM_ID inventory_item_id,
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,
1541: OE_ORDER_LINES L,
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
1780: l_debug_line := 20;
1781:
1782: SELECT C1.NEXT_SEQ_NUM, (C2.NEXT_SEQ_NUM - C1.NEXT_SEQ_NUM +1)
1783: INTO l_sys_seq_num, l_inf_fence_ind
1784: FROM BOM_CALENDAR_DATES C1, MTL_PARAMETERS P, BOM_CALENDAR_DATES C2
1785: WHERE P.ORGANIZATION_ID= p_org_id
1786: AND P.CALENDAR_CODE = C1.CALENDAR_CODE
1787: AND C1.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
1788: AND C1.CALENDAR_DATE = TRUNC(sysdate)