Topics started by Dualta

1 Topic

D
Do Gooder (Partner)
DualtaDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

CONNECT_BY_ISLEAF multiply up QTY_PER_ASSEMBLEY

Using connect pror query belowhow would you get the QTY_PRE_ASSEMBLEY multiplying as it goes down each level?ORConvert this  EQUATE_THIS coloum I have into as resule i.e *1*8*.022222 becomes 0.16 help   Select  PS.PART_NO As parent_part,  PS.COMPONENT_PART As child_part,  Level,  PS.LINE_ITEM_NO,  Sys_Connect_By_Path(PS.COMPONENT_PART, '\') As STRUCTURE_PATH,  CONNECT_BY_ISLEAF,  Case When PS.QTY_PER_ASSEMBLY < 0 Then 'BY-PRODUCT' Else 'COMPONENTS'  End As TYPE,  PS.QTY_PER_ASSEMBLY As QTY_PER_ASSEMBLY1,  Sys_Connect_By_Path(PS.QTY_PER_ASSEMBLY, '*') As EQUATE_THISFrom  PROD_STRUCTURE_HEAD PSH Inner Join  PART_REVISION PR On PR.CONTRACT = PSH.CONTRACT And PR.PART_NO = PSH.PART_NO    And PR.ENG_CHG_LEVEL = PSH.ENG_CHG_LEVEL Inner Join  PROD_STRUCT_ALTERNATE PSA On PSA.CONTRACT = PSH.CONTRACT And    PSA.PART_NO = PSH.PART_NO And PSA.ENG_CHG_LEVEL = PSH.ENG_CHG_LEVEL And    PSA.BOM_TYPE_DB = PSH.BOM_TYPE_DB And PSA.ALTERNATIVE_NO = '*' Inner Join  PROD_STRUCTURE PS On PS.CONTRACT = PSA

2
durette
Superhero (Customer)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings