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.CSP_EXCESS_PARTS_PVT dependencies on CST_ITEM_COSTS

Line 774: from CST_ITEM_COSTS cic,

770: br_rec business_rule%rowtype;
771:
772: cursor excess_value is
773: select sum(cel.excess_quantity * NVL(ITEM_COST,0))
774: from CST_ITEM_COSTS cic,
775: CST_COST_TYPES cct,
776: csp_excess_lists cel
777: where cic.ORGANIZATION_ID = cel.organization_id
778: and cic.inventory_item_id = cel.inventory_item_id

Line 785: from CST_ITEM_COSTS cic,

781: and cel.excess_status = 'P';
782:
783: cursor org_max_value is
784: select sum(msib.max_minmax_quantity * NVL(ITEM_COST,0))
785: from CST_ITEM_COSTS cic,
786: CST_COST_TYPES cct,
787: mtl_system_items_b msib
788: where msib.organization_id = p_organization_id
789: and cic.ORGANIZATION_ID = msib.organization_id

Line 797: from cst_item_costs cic,

793: and msib.max_minmax_quantity > 0;
794:
795: cursor sub_max_value is
796: select sum(misi.max_minmax_quantity * nvl(cic.item_cost,0))
797: from cst_item_costs cic,
798: cst_cost_types cct,
799: mtl_item_sub_inventories misi
800: where misi.organization_id = p_organization_id
801: and misi.secondary_inventory = p_subinventory_code

Line 860: from CST_ITEM_COSTS cic,

856:
857: cursor excess_line_value is
858: select cel.excess_line_id,
859: cel.excess_quantity * NVL(ITEM_COST,0) value
860: from CST_ITEM_COSTS cic,
861: CST_COST_TYPES cct,
862: csp_excess_lists cel
863: where cel.organization_id = p_organization_id
864: and cic.ORGANIZATION_ID = cel.organization_id