[Home] [Help]
357: V.INVENTORY_ITEM_ID inventory_item_id,
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,
393: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
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,
468: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
469: V.INVENTORY_ITEM_ID inventory_item_id,
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,
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
589: AND V.AVAILABLE_TO_ATP = 1
684: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
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
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
783: AND O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
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
879: WHERE V.ATP_GROUP_ID = P_GROUP_ID
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
879: WHERE V.ATP_GROUP_ID = P_GROUP_ID
880: AND V.AVAILABLE_TO_ATP = 1
964: V.INVENTORY_ITEM_ID inventory_item_id,
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
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
1062: WHERE O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
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
1062: WHERE O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
1063: AND O.ORGANIZATION_ID = V.ORGANIZATION_ID
1064: AND O.WIP_SUPPLY_TYPE <> 6
1065: AND O.REQUIRED_QUANTITY > 0
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,
1161: WIP_REQUIREMENT_OPERATIONS WRO
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,
1161: WIP_REQUIREMENT_OPERATIONS WRO
1162: WHERE WRO.ORGANIZATION_ID = V.ORGANIZATION_ID
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
1263: AND V.AVAILABLE_TO_ATP = 1
1264: AND V.ATP_RULE_ID = R.RULE_ID
1336: F.alternate_bom_designator alternate_bom_designator
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
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
1460: WHERE D.ORGANIZATION_ID = V.ORGANIZATION_ID
1461: AND D.PRIMARY_UOM_QUANTITY > GREATEST(NVL(D.RESERVATION_QUANTITY,0),D.COMPLETED_QUANTITY)
1455: MTL_SYSTEM_ITEMS I,
1456: MTL_ATP_RULES R,
1457: BOM_CALENDAR_DATES C,
1458: MTL_DEMAND D,
1459: BOM_CALENDAR_DATES C1
1460: WHERE D.ORGANIZATION_ID = V.ORGANIZATION_ID
1461: AND D.PRIMARY_UOM_QUANTITY > GREATEST(NVL(D.RESERVATION_QUANTITY,0),D.COMPLETED_QUANTITY)
1462: AND D.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1463: AND D.AVAILABLE_TO_ATP = 1
1536: -1*(L.ORDERED_QUANTITY-NVL(SHIPPED_QUANTITY, 0)) supply_demand_quantity,
1537: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1538: I.INVENTORY_ITEM_ID inventory_item_id,
1539: I.ORGANIZATION_ID organization_id
1540: FROM BOM_CALENDAR_DATES C ,
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 */
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)