DBA Data[Home] [Help]

APPS.MRP_MRPRPSST_XMLP_PKG dependencies on MRP_SCHEDULE_DESIGNATORS

Line 245: MRP_SCHEDULE_DESIGNATORS SCHED

241: SELECT
242: ORGANIZATION_SELECTION
243: INTO ORG_SELECTION
244: FROM
245: MRP_SCHEDULE_DESIGNATORS SCHED
246: WHERE ORGANIZATION_ID = P_ORG_ID
247: AND SCHEDULE_DESIGNATOR = P_SCHED_NAME;
248: IF (ORG_SELECTION = 2 OR ORG_SELECTION = 3) THEN
249: USE_MULTIORG_MPS := 1;

Line 306: MRP_SCHEDULE_DESIGNATORS SCHED

302: SELECT
303: ORGANIZATION_SELECTION
304: INTO ORG_SELECTION
305: FROM
306: MRP_SCHEDULE_DESIGNATORS SCHED
307: WHERE ORGANIZATION_ID = P_ORG_ID
308: AND SCHEDULE_DESIGNATOR = P_SCHED_NAME;
309: ELSIF (P_SCHED_TYPE = 2 AND P_REPORT_MULTIORG = 1) THEN
310: SELECT

Line 316: MRP_SCHEDULE_DESIGNATORS SCHED,

312: NVL(SCHED.ORGANIZATION_SELECTION
313: ,0)
314: INTO ORG_SELECTION
315: FROM
316: MRP_SCHEDULE_DESIGNATORS SCHED,
317: MRP_ORGANIZATIONS_V MO
318: WHERE SCHED.ORGANIZATION_ID = mo.organization_id (+)
319: AND SCHED.SCHEDULE_DESIGNATOR = mo.compile_designator (+)
320: AND NVL(MO.PLANNED_ORGANIZATION