DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on BOM_PERIOD_START_DATES

Line 1204: BOM_PERIOD_START_DATES PER,

1200: INTO PERIOD_FC_QTY
1201: FROM
1202: BOM_CALENDAR_DATES CAL1,
1203: BOM_CALENDAR_DATES CAL2,
1204: BOM_PERIOD_START_DATES PER,
1205: MRP_FORECAST_DATES FC,
1206: MRP_FORECAST_DESIGNATORS DESIG1,
1207: MRP_FORECAST_DESIGNATORS DESIG2
1208: WHERE DESIG2.FORECAST_DESIGNATOR = FORECAST_DESIG

Line 1314: BOM_PERIOD_START_DATES PER

1310: NVL(MAX(PER.NEXT_DATE)
1311: ,TRUNC(SYSDATE))
1312: INTO PERIOD_START_DATE,PERIOD_END_DATE
1313: FROM
1314: BOM_PERIOD_START_DATES PER
1315: WHERE PER.CALENDAR_CODE = CAL_CODE
1316: AND PER.EXCEPTION_SET_ID = EXC_SET_ID
1317: AND PER.PERIOD_START_DATE <= TRUNC(SYSDATE);
1318: FC_QTY := GET_FORECAST_QUANTITY(ITEM_ID