eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_SYNC_INVENTORY_PKG dependencies on CLN_INVENTORY_REPORT_V

Line 160: FROM CLN_INVENTORY_REPORT_V

156: --SELECT inventory_item_id
157: SELECT 'x' INTO l_dummy_check FROM DUAL
158: WHERE EXISTS(
159: SELECT 'x'
160: FROM CLN_INVENTORY_REPORT_V
161: WHERE organization_id = p_inv_org
162: AND (concatenated_segments BETWEEN nvl(p_item_number_from,concatenated_segments) AND nvl(p_item_number_to,concatenated_segments))
163: AND (((p_item_revision_from IS NULL OR p_item_revision_to IS NULL) AND CLN_INVENTORY_REPORT_V.REVISION_QTY_CONTROL_CODE =1)or revision BETWEEN nvl(p_item_revision_from,revision) AND nvl(p_item_revision_to,revision))
164: AND EXISTS ( SELECT 'X' FROM MTL_ITEM_CATEGORIES MIC

Line 163: AND (((p_item_revision_from IS NULL OR p_item_revision_to IS NULL) AND CLN_INVENTORY_REPORT_V.REVISION_QTY_CONTROL_CODE =1)or revision BETWEEN nvl(p_item_revision_from,revision) AND nvl(p_item_revision_to,revision))

159: SELECT 'x'
160: FROM CLN_INVENTORY_REPORT_V
161: WHERE organization_id = p_inv_org
162: AND (concatenated_segments BETWEEN nvl(p_item_number_from,concatenated_segments) AND nvl(p_item_number_to,concatenated_segments))
163: AND (((p_item_revision_from IS NULL OR p_item_revision_to IS NULL) AND CLN_INVENTORY_REPORT_V.REVISION_QTY_CONTROL_CODE =1)or revision BETWEEN nvl(p_item_revision_from,revision) AND nvl(p_item_revision_to,revision))
164: AND EXISTS ( SELECT 'X' FROM MTL_ITEM_CATEGORIES MIC
165: WHERE (CLN_INVENTORY_REPORT_V.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+)
166: AND CLN_INVENTORY_REPORT_V.ORGANIZATION_ID = MIC.ORGANIZATION_ID(+))
167: AND MIC.category_id = nvl(p_item_category,MIC.category_id))

Line 165: WHERE (CLN_INVENTORY_REPORT_V.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+)

161: WHERE organization_id = p_inv_org
162: AND (concatenated_segments BETWEEN nvl(p_item_number_from,concatenated_segments) AND nvl(p_item_number_to,concatenated_segments))
163: AND (((p_item_revision_from IS NULL OR p_item_revision_to IS NULL) AND CLN_INVENTORY_REPORT_V.REVISION_QTY_CONTROL_CODE =1)or revision BETWEEN nvl(p_item_revision_from,revision) AND nvl(p_item_revision_to,revision))
164: AND EXISTS ( SELECT 'X' FROM MTL_ITEM_CATEGORIES MIC
165: WHERE (CLN_INVENTORY_REPORT_V.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+)
166: AND CLN_INVENTORY_REPORT_V.ORGANIZATION_ID = MIC.ORGANIZATION_ID(+))
167: AND MIC.category_id = nvl(p_item_category,MIC.category_id))
168: AND EXISTS (
169: SELECT 'X' FROM mtl_secondary_inventories msi, mtl_onhand_quantities_detail moqd

Line 166: AND CLN_INVENTORY_REPORT_V.ORGANIZATION_ID = MIC.ORGANIZATION_ID(+))

162: AND (concatenated_segments BETWEEN nvl(p_item_number_from,concatenated_segments) AND nvl(p_item_number_to,concatenated_segments))
163: AND (((p_item_revision_from IS NULL OR p_item_revision_to IS NULL) AND CLN_INVENTORY_REPORT_V.REVISION_QTY_CONTROL_CODE =1)or revision BETWEEN nvl(p_item_revision_from,revision) AND nvl(p_item_revision_to,revision))
164: AND EXISTS ( SELECT 'X' FROM MTL_ITEM_CATEGORIES MIC
165: WHERE (CLN_INVENTORY_REPORT_V.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+)
166: AND CLN_INVENTORY_REPORT_V.ORGANIZATION_ID = MIC.ORGANIZATION_ID(+))
167: AND MIC.category_id = nvl(p_item_category,MIC.category_id))
168: AND EXISTS (
169: SELECT 'X' FROM mtl_secondary_inventories msi, mtl_onhand_quantities_detail moqd
170: WHERE msi.organization_id = moqd.organization_id

Line 172: AND msi.organization_id = CLN_INVENTORY_REPORT_V.organization_id

168: AND EXISTS (
169: SELECT 'X' FROM mtl_secondary_inventories msi, mtl_onhand_quantities_detail moqd
170: WHERE msi.organization_id = moqd.organization_id
171: AND msi.secondary_inventory_name = moqd.subinventory_code
172: AND msi.organization_id = CLN_INVENTORY_REPORT_V.organization_id
173: AND msi.secondary_inventory_name = NVL(p_sub_inv,msi.secondary_inventory_name)
174: AND moqd.inventory_item_id = CLN_INVENTORY_REPORT_V.inventory_item_id
175: AND (CLN_INVENTORY_REPORT_V.revision IS NULL OR moqd.revision IS NULL OR moqd.revision = CLN_INVENTORY_REPORT_V.revision)
176: )

Line 174: AND moqd.inventory_item_id = CLN_INVENTORY_REPORT_V.inventory_item_id

170: WHERE msi.organization_id = moqd.organization_id
171: AND msi.secondary_inventory_name = moqd.subinventory_code
172: AND msi.organization_id = CLN_INVENTORY_REPORT_V.organization_id
173: AND msi.secondary_inventory_name = NVL(p_sub_inv,msi.secondary_inventory_name)
174: AND moqd.inventory_item_id = CLN_INVENTORY_REPORT_V.inventory_item_id
175: AND (CLN_INVENTORY_REPORT_V.revision IS NULL OR moqd.revision IS NULL OR moqd.revision = CLN_INVENTORY_REPORT_V.revision)
176: )
177: AND ( (p_lot_number IS NULL AND CLN_INVENTORY_REPORT_V.LOT_CONTROL_CODE = 1) OR
178: EXISTS (

Line 175: AND (CLN_INVENTORY_REPORT_V.revision IS NULL OR moqd.revision IS NULL OR moqd.revision = CLN_INVENTORY_REPORT_V.revision)

171: AND msi.secondary_inventory_name = moqd.subinventory_code
172: AND msi.organization_id = CLN_INVENTORY_REPORT_V.organization_id
173: AND msi.secondary_inventory_name = NVL(p_sub_inv,msi.secondary_inventory_name)
174: AND moqd.inventory_item_id = CLN_INVENTORY_REPORT_V.inventory_item_id
175: AND (CLN_INVENTORY_REPORT_V.revision IS NULL OR moqd.revision IS NULL OR moqd.revision = CLN_INVENTORY_REPORT_V.revision)
176: )
177: AND ( (p_lot_number IS NULL AND CLN_INVENTORY_REPORT_V.LOT_CONTROL_CODE = 1) OR
178: EXISTS (
179: SELECT 'X' FROM MTL_LOT_NUMBERS MLN

Line 177: AND ( (p_lot_number IS NULL AND CLN_INVENTORY_REPORT_V.LOT_CONTROL_CODE = 1) OR

173: AND msi.secondary_inventory_name = NVL(p_sub_inv,msi.secondary_inventory_name)
174: AND moqd.inventory_item_id = CLN_INVENTORY_REPORT_V.inventory_item_id
175: AND (CLN_INVENTORY_REPORT_V.revision IS NULL OR moqd.revision IS NULL OR moqd.revision = CLN_INVENTORY_REPORT_V.revision)
176: )
177: AND ( (p_lot_number IS NULL AND CLN_INVENTORY_REPORT_V.LOT_CONTROL_CODE = 1) OR
178: EXISTS (
179: SELECT 'X' FROM MTL_LOT_NUMBERS MLN
180: WHERE CLN_INVENTORY_REPORT_V.inventory_item_id = mln.inventory_item_id(+)
181: AND CLN_INVENTORY_REPORT_V.organization_id = mln.organization_id(+)

Line 180: WHERE CLN_INVENTORY_REPORT_V.inventory_item_id = mln.inventory_item_id(+)

176: )
177: AND ( (p_lot_number IS NULL AND CLN_INVENTORY_REPORT_V.LOT_CONTROL_CODE = 1) OR
178: EXISTS (
179: SELECT 'X' FROM MTL_LOT_NUMBERS MLN
180: WHERE CLN_INVENTORY_REPORT_V.inventory_item_id = mln.inventory_item_id(+)
181: AND CLN_INVENTORY_REPORT_V.organization_id = mln.organization_id(+)
182: AND mln.lot_number = NVL(p_lot_number,mln.lot_number)
183: )
184: )

Line 181: AND CLN_INVENTORY_REPORT_V.organization_id = mln.organization_id(+)

177: AND ( (p_lot_number IS NULL AND CLN_INVENTORY_REPORT_V.LOT_CONTROL_CODE = 1) OR
178: EXISTS (
179: SELECT 'X' FROM MTL_LOT_NUMBERS MLN
180: WHERE CLN_INVENTORY_REPORT_V.inventory_item_id = mln.inventory_item_id(+)
181: AND CLN_INVENTORY_REPORT_V.organization_id = mln.organization_id(+)
182: AND mln.lot_number = NVL(p_lot_number,mln.lot_number)
183: )
184: )
185: );