APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_PRD_DISPOSITIONS_B

Line 1729: FROM AHL_PRD_DISPOSITIONS_B DISP,

1725: SELECT SUM(quantity)
1726: FROM (
1727: /* STHILAK bug #13641891 : commented the query and framed the modified query
1728: SELECT 1 quantity
1729: FROM AHL_PRD_DISPOSITIONS_B DISP,
1730: AHL_WORKORDERS WO,
1731: CSI_ITEM_INSTANCES CSI
1732: WHERE DISP.workorder_id = WO.workorder_id
1733: AND DISP.instance_id = CSI.instance_id

Line 1744: FROM AHL_PRD_DISPOSITIONS_B DISP,

1740: UNION ALL
1741:
1742: -- For non serial controlled items
1743: SELECT DISP.quantity quantity
1744: FROM AHL_PRD_DISPOSITIONS_B DISP,
1745: AHL_WORKORDERS WO,
1746: CSI_ITEM_INSTANCES CSI
1747: WHERE DISP.workorder_id = WO.workorder_id
1748: AND DISP.inventory_item_id = CSI.inventory_item_id

Line 1758: FROM AHL_PRD_DISPOSITIONS_B DISP,

1754: AND CSI.serial_number IS NULL
1755: AND CSI.instance_id = c_instance_id */
1756:
1757: SELECT 1 quantity
1758: FROM AHL_PRD_DISPOSITIONS_B DISP,
1759: CSI_ITEM_INSTANCES CSI
1760: WHERE DISP.instance_id = CSI.instance_id
1761: AND CSI.instance_id = c_instance_id
1762: AND CSI.location_type_code = 'WIP'

Line 1772: FROM AHL_PRD_DISPOSITIONS_B DISP,

1768:
1769: UNION ALL
1770:
1771: SELECT DISP.quantity quantity
1772: FROM AHL_PRD_DISPOSITIONS_B DISP,
1773: CSI_ITEM_INSTANCES CSI
1774: WHERE DISP.inventory_item_id = CSI.inventory_item_id
1775: AND CSI.location_type_code = 'WIP'
1776: AND CSI.serial_number IS NULL