APPS.FLM_SUPPLY_DEMAND dependencies on MTL_GROUP_ATPS_VIEW

Line 871: MTL_GROUP_ATPS_VIEW V,

867: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
868: V.INVENTORY_ITEM_ID inventory_item_id,
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,

Line 1494: FROM MTL_GROUP_ATPS_VIEW V1

1490: 3, I.PREPROCESSING_LEAD_TIME+I.FULL_LEAD_TIME+I.POSTPROCESSING_LEAD_TIME,
1491: 4, R.INFINITE_SUPPLY_TIME_FENCE)), C.PRIOR_SEQ_NUM+1))
1492: AND NOT EXISTS
1493: (SELECT 'exists in group?'
1494: FROM MTL_GROUP_ATPS_VIEW V1
1495: WHERE V1.ATP_GROUP_ID = P_GROUP_ID
1496: AND V1.ORGANIZATION_ID + 0 = V.ORGANIZATION_ID
1497: AND V1.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1498: AND V1.AVAILABLE_TO_ATP = 1

Line 1543: /* MTL_GROUP_ATPS_VIEW G , */

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 */
1545: MTL_PARAMETERS P ,
1546: MTL_SYSTEM_ITEMS I
1547: WHERE I.ATP_FLAG in ('C', 'Y')

Line 1868: INSERT INTO MTL_GROUP_ATPS_VIEW (

1864: );
1865:
1866: l_debug_line := 40;
1867: FOR item_index in 1..p_item_id_tbl.count LOOP
1868: INSERT INTO MTL_GROUP_ATPS_VIEW (
1869: ATP_GROUP_ID,
1870: ORGANIZATION_ID,
1871: INVENTORY_ITEM_ID,
1872: LAST_UPDATE_DATE,