[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
sqltxt := ' select ' ||
' mp.organization_code|| '' (''||moqd.organization_id ||'')'' "Organization|Code (Id)"' ||
' ,mif.item_number|| '' (''||moqd.inventory_item_id||'')'' "Item (Id)",' ||
' mil.project_id "Proj Id",' ||
' mil.segment19 "Segment 19",' ||
' moqd.subinventory_code "subinv",' ||
' moqd.locator_id "Locator",' ||
' moqd.cost_group_id "Cost group id",' ||
' mproj.costing_group_id "Proj cost group id"' ||
' from mtl_onhand_quantities_detail moqd,' ||
' mtl_parameters mp,' ||
' mtl_item_flexfields mif,' ||
' mtl_item_locations_kfv mil,' ||
' mrp_project_parameters mproj' ||
' where moqd.inventory_item_id=mif.inventory_item_id' ||
' and moqd.organization_id=mif.organization_id' ||
' and moqd.organization_id=mp.organization_id' ||
' and moqd.organization_id=mil.organization_id' ||
' and moqd.locator_id=mil.inventory_location_id' ||
' and mil.project_id=mproj.project_id' ||
' and mil.organization_id=mproj.organization_id ' ||
' and mproj.costing_group_id <> moqd.cost_group_id ';