APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_VISITS_B

Line 1681: from AHL_VISITS_B Visit,

1677: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)
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

Line 1704: from AHL_VISITS_B Visit,

1700: -- Total Quantity from Root Node of a Visit.
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')

Line 1725: AHL_VISITS_B Visit,

1721: -- Without Tree Reversal
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')

Line 1755: AHL_VISITS_B Visit,

1751: AND CII.INSTANCE_ID = CIIR.SUBJECT_ID
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')