pardeshirahul
asked on
How to achive this from this select
select
ORG,
OWNING_ORGANIZATION_NAME,
INTRANSIT_QTY ,
SUB_INVENTORY ,
LOCATOR ,
ITEM ,
DESCRIPTION,
ON_HAND ,
STD_COST ,
EXTEND_COST,
ITEM_CATELOG_CATEGORY,
MAKE_OR_BUY ,
FAMILY ,
PLANNER
from tpco_intransit
look at the column intransit
the value is 200 for 4 subinventories
the is for the ORG 116 and item 12063
the way i want the output to be
in the Yellow marking i want the intransit qty as 200 repeat only once
irrecpective of subinventories
and the value 200 in the place of Onhand
This-is-what-i-want.docx
ORG,
OWNING_ORGANIZATION_NAME,
INTRANSIT_QTY ,
SUB_INVENTORY ,
LOCATOR ,
ITEM ,
DESCRIPTION,
ON_HAND ,
STD_COST ,
EXTEND_COST,
ITEM_CATELOG_CATEGORY,
MAKE_OR_BUY ,
FAMILY ,
PLANNER
from tpco_intransit
look at the column intransit
the value is 200 for 4 subinventories
the is for the ORG 116 and item 12063
the way i want the output to be
in the Yellow marking i want the intransit qty as 200 repeat only once
irrecpective of subinventories
and the value 200 in the place of Onhand
This-is-what-i-want.docx
ASKER
and i want to remove intransit_qty column
and show it as the row displayed
and show it as the row displayed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the intransit_qty
and is specified as SUb
now i want to shouw the data as if intransit is one more sub inventory and the value of it is 200 in onhand qty