APPS.WPS_SUPPLY_DEMAND dependencies on MTL_GROUP_ATPS_VIEW

Line 877: MTL_GROUP_ATPS_VIEW V,

873: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
874: V.INVENTORY_ITEM_ID inventory_item_id,
875: V.ORGANIZATION_ID organization_id
876: FROM
877: MTL_GROUP_ATPS_VIEW V,
878: MTL_ATP_RULES R,
879: MTL_SYSTEM_ITEMS I,
880: MTL_PARAMETERS P,
881: BOM_CALENDAR_DATES C,

Line 1485: FROM MTL_GROUP_ATPS_VIEW V1

1481: 3, I.PREPROCESSING_LEAD_TIME+I.FULL_LEAD_TIME+I.POSTPROCESSING_LEAD_TIME,
1482: 4, R.INFINITE_SUPPLY_TIME_FENCE)), C.PRIOR_SEQ_NUM+1))
1483: AND NOT EXISTS
1484: (SELECT 'exists in group?'
1485: FROM MTL_GROUP_ATPS_VIEW V1
1486: WHERE V1.ATP_GROUP_ID = P_GROUP_ID
1487: AND V1.ORGANIZATION_ID + 0 = V.ORGANIZATION_ID
1488: AND V1.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1489: AND V1.AVAILABLE_TO_ATP = 1

Line 1534: MTL_GROUP_ATPS_VIEW G ,

1530: I.ORGANIZATION_ID organization_id
1531: FROM BOM_CALENDAR_DATES C ,
1532: OE_ORDER_LINES L,
1533: MTL_ATP_RULES R ,
1534: MTL_GROUP_ATPS_VIEW G ,
1535: MTL_PARAMETERS P ,
1536: MTL_SYSTEM_ITEMS I
1537: WHERE I.ATP_FLAG in ('C', 'Y')
1538: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID