DBA Data[Home] [Help]

APPS.MRP_MRPRPPIT_XMLP_PKG dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 59: MRP_PLAN_ORGANIZATIONS_V ORG_V,

55: ORG_V.COMPILE_DESIGNATOR,
56: PLN_SCHED.INPUT_DESIGNATOR_NAME,
57: ORG_V.PLANNED_ORGANIZATION
58: FROM
59: MRP_PLAN_ORGANIZATIONS_V ORG_V,
60: MRP_PLAN_SCHEDULES_V PLN_SCHED
61: WHERE PLN_SCHED.INPUT_ORGANIZATION_ID = ORG_V.PLANNED_ORGANIZATION
62: AND PLN_SCHED.COMPILE_DESIGNATOR = ORG_V.COMPILE_DESIGNATOR
63: AND DECODE(P_ORG_TYPE

Line 113: MRP_PLAN_ORGANIZATIONS_V ORG_V,

109: PLAN.PLAN_COMPLETION_DATE,
110: PLAN.PLAN_COMPLETION_DATE
111: INTO EXPLOSION_DATE,SNAPSHOT_DATE,PLAN_DATE,START_DATE
112: FROM
113: MRP_PLAN_ORGANIZATIONS_V ORG_V,
114: MRP_PLANS PLAN
115: WHERE DECODE(P_ORG_TYPE
116: ,1
117: ,ORG_V.PLANNED_ORGANIZATION

Line 210: MRP_PLAN_ORGANIZATIONS_V

206: DISTINCT
207: ORGANIZATION_SELECTION
208: INTO ORG_SELECTION
209: FROM
210: MRP_PLAN_ORGANIZATIONS_V
211: WHERE DECODE(P_ORG_TYPE
212: ,1
213: ,PLANNED_ORGANIZATION
214: ,ORGANIZATION_ID) = P_ORG_ID