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.

VIEW: APPS.CSP_AVAILABLE_PARTS_IN_LOOP_V

Source

View Text - Preformatted


SELECT cplb.parts_loop_id, cplb.organization_id, csi.secondary_inventory_name, csi.condition_type, csp_validate_pub.get_avail_qty( cplb.organization_id, csi.secondary_inventory_name, null, mosv.inventory_item_id), mosv.inventory_item_id, mosv.revision FROM mtl_onhand_sub_v mosv, csp_parts_loops_b cplb, csp_sec_inventories csi WHERE mosv.organization_id = cplb.organization_id AND csi.parts_loop_id = cplb.parts_loop_id AND csi.organization_id = cplb.organization_id AND csi.secondary_inventory_name = mosv.subinventory_code

View Text - HTML Formatted

SELECT CPLB.PARTS_LOOP_ID
, CPLB.ORGANIZATION_ID
, CSI.SECONDARY_INVENTORY_NAME
, CSI.CONDITION_TYPE
, CSP_VALIDATE_PUB.GET_AVAIL_QTY( CPLB.ORGANIZATION_ID
, CSI.SECONDARY_INVENTORY_NAME
, NULL
, MOSV.INVENTORY_ITEM_ID)
, MOSV.INVENTORY_ITEM_ID
, MOSV.REVISION
FROM MTL_ONHAND_SUB_V MOSV
, CSP_PARTS_LOOPS_B CPLB
, CSP_SEC_INVENTORIES CSI
WHERE MOSV.ORGANIZATION_ID = CPLB.ORGANIZATION_ID
AND CSI.PARTS_LOOP_ID = CPLB.PARTS_LOOP_ID
AND CSI.ORGANIZATION_ID = CPLB.ORGANIZATION_ID
AND CSI.SECONDARY_INVENTORY_NAME = MOSV.SUBINVENTORY_CODE