APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_SIMULATION_PLANS_B

Line 1682: AHL_SIMULATION_PLANS_B SPL

1678: AND CII.INSTANCE_ID = CIIR.SUBJECT_ID
1679: START WITH CIIR.OBJECT_ID IN (
1680: Select DISTINCT Visit.ITEM_INSTANCE_ID
1681: from AHL_VISITS_B Visit,
1682: AHL_SIMULATION_PLANS_B SPL
1683: Where Visit.unit_Schedule_id is NULL
1684: AND VISIT.STATUS_CODE NOT IN ('CLOSED', 'CANCELLED', 'DELETED')
1685: AND SPL.SIMULATION_PLAN_ID = VISIT.SIMULATION_PLAN_ID
1686: AND SPL.PRIMARY_PLAN_FLAG = 'Y'

Line 1705: AHL_SIMULATION_PLANS_B SPL,

1701:
1702: Select Visit.ITEM_INSTANCE_ID AS ITEM_INSTANCE,
1703: CII.QUANTITY AS VISIT_QUANTITY
1704: from AHL_VISITS_B Visit,
1705: AHL_SIMULATION_PLANS_B SPL,
1706: CSI_ITEM_INSTANCES CII
1707: Where Visit.unit_Schedule_id is NOT NULL
1708: AND VISIT.STATUS_CODE NOT IN ('CLOSED', 'CANCELLED', 'DELETED')
1709: AND SPL.SIMULATION_PLAN_ID = VISIT.SIMULATION_PLAN_ID

Line 1726: AHL_SIMULATION_PLANS_B SPL,

1722: Select CII.INSTANCE_ID AS ITEM_INSTANCE,
1723: CII.QUANTITY AS VISIT_QUANTITY
1724: from AHL_VISIT_TASKS_B TASKS,
1725: AHL_VISITS_B Visit,
1726: AHL_SIMULATION_PLANS_B SPL,
1727: CSI_ITEM_INSTANCES CII
1728: Where Visit.VISIT_ID = TASKS.Visit_id
1729: AND VISIT.STATUS_CODE NOT IN ('CLOSED', 'CANCELLED', 'DELETED')
1730: AND SPL.SIMULATION_PLAN_ID = VISIT.SIMULATION_PLAN_ID

Line 1756: AHL_SIMULATION_PLANS_B SPL,

1752: START WITH CIIR.OBJECT_ID IN (
1753: Select CII.INSTANCE_ID AS ITEM_INSTANCE
1754: from AHL_VISIT_TASKS_B TASKS,
1755: AHL_VISITS_B Visit,
1756: AHL_SIMULATION_PLANS_B SPL,
1757: CSI_ITEM_INSTANCES CII
1758: Where Visit.VISIT_ID = TASKS.Visit_id
1759: AND VISIT.STATUS_CODE NOT IN ('CLOSED', 'CANCELLED', 'DELETED')
1760: AND SPL.SIMULATION_PLAN_ID = VISIT.SIMULATION_PLAN_ID