DBA Data[Home] [Help]

APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_VISIT_TASKS_B

Line 1724: from AHL_VISIT_TASKS_B TASKS,

1720: -- Total Quantity from Visit, which does not have a unit at the header level.
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

Line 1754: from AHL_VISIT_TASKS_B TASKS,

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