[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)" ' ||
' ,moqd.subinventory_code "Subinv", moqd.locator_id "Loc id",moqd.lot_number "Lot number",moqd.revision "Rev" ' ||
' from mtl_onhand_quantities_detail moqd,' ||
' mtl_parameters mp,mtl_item_flexfields mif' ||
' where moqd.organization_id = mp.organization_id' ||
' and moqd.inventory_item_id = mif.inventory_item_id' ||
' and moqd.organization_id = mif.organization_id' ||
' and moqd.locator_id is not null and moqd.locator_id <> -1' ||
' and moqd.organization_id = ' || l_org_id ||
' and EXISTS (SELECT 1' ||
' FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I' ||
' WHERE I.INVENTORY_ITEM_ID = moqd.INVENTORY_ITEM_ID' ||
' AND S.SECONDARY_INVENTORY_NAME = moqd.SUBINVENTORY_CODE' ||
' AND P.ORGANIZATION_ID = moqd.ORGANIZATION_ID' ||
' AND I.ORGANIZATION_ID = S.ORGANIZATION_ID' ||
' AND P.ORGANIZATION_ID = S.ORGANIZATION_ID' ||
' AND P.ORGANIZATION_ID = I.ORGANIZATION_ID' ||
' AND (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE, S.LOCATOR_TYPE),' ||
' P.STOCK_LOCATOR_CONTROL_CODE) = 1))' ||
' group by ' ||
' mp.organization_code || '' ('' || moqd.organization_id || '')'',' ||
' mif.item_number|| '' (''||moqd.inventory_item_id||'')'',' ||
' moqd.inventory_item_id, moqd.subinventory_code, moqd.locator_id, moqd.lot_number, moqd.revision' ;
sqltxt := ' select mp.organization_code|| '' (''||t.organization_id ||'')'' "Organization|Code (Id)"' ||
' ,mif.item_number|| '' (''|| t.inventory_item_id||'')'' "Item (Id)" ,' ||
' t.subinventory_code "Subinv", t.locator_id "Locator_id", t.lot_number "Lot num", t.revision "Rev"' ||
' from temp_disc_inv_cg_loose t, mtl_parameters mp, mtl_item_flexfields mif' ||
' where ' ||
' t.organization_id = mp.organization_id(+)' ||
' and t.inventory_item_id = mif.inventory_item_id(+)' ||
' and t.organization_id = mif.organization_id(+)' ||
' and t.locator_id is not null and t.locator_id <> -1 ' ||
' and EXISTS (SELECT 1' ||
' FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I' ||
' WHERE I.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID' ||
' AND S.SECONDARY_INVENTORY_NAME = t.SUBINVENTORY_CODE' ||
' AND P.ORGANIZATION_ID = t.ORGANIZATION_ID' ||
' AND I.ORGANIZATION_ID = S.ORGANIZATION_ID' ||
' AND P.ORGANIZATION_ID = S.ORGANIZATION_ID' ||
' AND P.ORGANIZATION_ID = I.ORGANIZATION_ID' ||
' AND (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE, S.LOCATOR_TYPE),' ||
' P.STOCK_LOCATOR_CONTROL_CODE) = 1))' ||
' group by ' ||
' mp.organization_code || '' ('' || t.organization_id || '')'',' ||
' mif.item_number|| '' (''||t.inventory_item_id||'')'',' ||
' t.subinventory_code, t.locator_id, t.lot_number, t.revision';