| Author |
Message |
    
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9445
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, April 08, 2009 - 4:58 pm: |
|
Rratna:Bemmam maya BTDB ni kevalam nee professional growth ki use chestunnav?
 |
Rratna
Bewarse Legend
Username: Rratna
Post Number: 11247
Registered: 03-2004
Posted From: 24.172.181.227
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, April 08, 2009 - 4:49 pm: |
|
Bemmam maya BTDB ni kevalam nee professional growth ki use chestunnav? |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9443
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, April 08, 2009 - 4:28 pm: |
|
 |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 60180
Registered: 07-2004
Posted From: 148.168.127.10
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, April 08, 2009 - 4:25 pm: |
|
cool....vaake
Bewarse Legend Of The Year 2008 Award winner 
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9442
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, April 08, 2009 - 4:23 pm: |
|
idi work avuthundi gochesh.. thanks for your suggestion adi oka part ga use ayyindi..inka union raasi vere di koda work ayyelaga chesa..kiki |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9441
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, April 08, 2009 - 4:23 pm: |
|
SELECT msi.inventory_item_id,
msi.organization_id,
msi.segment1 bom_printed,
msi.description,
msi.attribute1 on_counter_date,
msi.attribute2 program_no,
msi.attribute12 upc_no,
msi.attribute5 retail_price,
NVL(bbom.alternate_bom_designator,'-') Alternate,
NVL(mir.revision,0) Revision,
decode(mcr.cross_reference_type, 'SCC14' , mcr.cross_reference, mcr_alias1.cross_reference) cross_reference
FROM mtl_system_items msi,
mtl_parameters mp,
mtl_item_revisions mir,
bom_bill_of_materials bbom,
mtl_cross_references mcr,
mtl_cross_references mcr_alias1
WHERE msi.organization_id = mp.organization_id
AND mp.organization_code = 'CUS'
AND msi.inventory_item_id = :bom_number
AND msi.inventory_item_id = mir.inventory_item_id
AND msi.inventory_item_id(+) = mcr.inventory_item_id
AND mcr.cross_reference_type = 'SCC14'
AND msi.inventory_item_id = mcr_alias1.inventory_item_id
AND mcr_alias1.cross_reference_type != 'SCC14'
AND msi.organization_id = mir.organization_id
AND NVL(UPPER(RTRIM(bbom.alternate_bom_designator)),'-') = NVL(UPPER(RTRIM(:alt_bom)),'-')
AND bbom.assembly_item_id = msi.inventory_item_id
AND bbom.organization_id = msi.organization_id
AND NVL(mir.revision,0)= (
SELECT NVL( max( NVL(:item_revision, mir2.revision)), 0)
FROM mtl_item_revisions mir2
WHERE mir2.revision < NVL(:item_revision,'ZZZ' )
AND mir2.inventory_item_id = :bom_number
AND mir2.organization_id = msi.organization_id )
UNION
SELECT msi.inventory_item_id,
msi.organization_id,
msi.segment1 bom_printed,
msi.description,
msi.attribute1 on_counter_date,
msi.attribute2 program_no,
msi.attribute12 upc_no,
msi.attribute5 retail_price,
NVL(bbom.alternate_bom_designator,'-') Alternate,
NVL(mir.revision,0) Revision,
NULL cross_reference
FROM mtl_system_items msi,
mtl_parameters mp,
mtl_item_revisions mir,
bom_bill_of_materials bbom,
mtl_cross_references mcr
WHERE msi.organization_id = mp.organization_id
AND mp.organization_code = 'CUS'
AND msi.inventory_item_id = :bom_number
AND msi.inventory_item_id = mir.inventory_item_id
AND msi.organization_id = mir.organization_id
AND msi.inventory_item_id = (select distinct mcr.inventory_item_id from mtl_cross_references mcr where mcr.cross_reference_type != 'SCC14'
and mcr.inventory_item_id = :bom_number
and not exists (select 1 from mtl_cross_references mcr
where mcr.cross_reference_type = 'SCC14'
AND mcr.inventory_item_id = :bom_number ) )
--AND mcr.cross_reference_type != 'SCC14'
AND NVL(UPPER(RTRIM(bbom.alternate_bom_designator)),'-') = NVL(UPPER(RTRIM(:alt_bom)),'-')
AND bbom.assembly_item_id = msi.inventory_item_id
AND bbom.organization_id = msi.organization_id
AND NVL(mir.revision,0)= (
SELECT NVL( max( NVL(:item_revision, mir2.revision)), 0)
FROM mtl_item_revisions mir2
WHERE mir2.revision < NVL(:item_revision,'ZZZ' )
AND mir2.inventory_item_id = :bom_number
AND mir2.organization_id = msi.organization_id ) |
Musicfan
Bewarse Legend
Username: Musicfan
Post Number: 14355
Registered: 05-2004
Posted From: 68.43.246.110
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:54 pm: |
|
ee bakugan kani pettina vadu evadu sami..
|
Musicfan
Bewarse Legend
Username: Musicfan
Post Number: 14354
Registered: 05-2004
Posted From: 68.43.246.110
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:54 pm: |
|
bemmam maya inka problem resolve avvaledaa
ee bakugan kani pettina vadu evadu sami..
|
Musicfan
Bewarse Legend
Username: Musicfan
Post Number: 14353
Registered: 05-2004
Posted From: 68.43.246.110
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:53 pm: |
|
evening working ayi poinda gochesh
ee bakugan kani pettina vadu evadu sami..
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9427
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:46 pm: |
|
konchem marchanu...union pettanu...rendu types of data vasthundi.kani union lo inka konchem modify cheyyali... |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9426
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:45 pm: |
|
latest ga rasina code valla ee problem undi mama..
if the cross_reference_type != 'SCC14' ayina item unte assala data ravatam ledu..
adee corss_reference_type = 'SCC14' unna item unte data vasthundi.. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 60118
Registered: 07-2004
Posted From: 24.229.138.244
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:35 pm: |
|
ippudu nuvvu latestgaa raasina querolo em problem vasthaandhi
Bewarse Legend Of The Year 2008 Award winner
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9425
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:33 pm: |
|
edanna UNION cheyyochemo chodali.. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 60117
Registered: 07-2004
Posted From: 24.229.138.244
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:33 pm: |
|
ippudu work ayyindaaa hemesh...
Bewarse Legend Of The Year 2008 Award winner
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9424
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:10 pm: |
|
SELECT msi.inventory_item_id,
msi.organization_id,
msi.segment1 bom_printed,
msi.description,
msi.attribute1 on_counter_date,
msi.attribute2 program_no,
msi.attribute12 upc_no,
msi.attribute5 retail_price,
NVL(bbom.alternate_bom_designator,'-') Alternate,
NVL(mir.revision,0) Revision,
decode(mcr.cross_reference_type, 'SCC14' , mcr.cross_reference, mcr_alias.cross_reference) cross_reference
FROM mtl_system_items msi,
mtl_parameters mp,
mtl_item_revisions mir,
bom_bill_of_materials bbom,
mtl_cross_references mcr,
mtl_cross_references mcr_alias
WHERE msi.organization_id = mp.organization_id
AND mp.organization_code = 'CUS'
AND msi.inventory_item_id = :bom_number
AND msi.inventory_item_id = mir.inventory_item_id
AND msi.inventory_item_id(+) = mcr.inventory_item_id
AND mcr.cross_reference_type = 'SCC14'
AND msi.inventory_item_id = mcr_alias.inventory_item_id
AND mcr_alias.cross_reference_type != 'SCC14'
AND msi.organization_id = mir.organization_id
AND NVL(UPPER(RTRIM(bbom.alternate_bom_designator)),'-') = NVL(UPPER(RTRIM(:alt_bom)),'-')
AND bbom.assembly_item_id = msi.inventory_item_id
AND bbom.organization_id = msi.organization_id
AND NVL(mir.revision,0)= (
SELECT NVL( max( NVL(:item_revision, mir2.revision)), 0)
FROM mtl_item_revisions mir2
WHERE mir2.revision < NVL(:item_revision,'ZZZ' )
AND mir2.inventory_item_id = :bom_number
AND mir2.organization_id = msi.organization_id ) |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9423
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 7:07 pm: |
|
partial ga work ayyindi mama...
if the cross_reference_type != 'SCC14' ayina item unte assala data ravatam ledu..
adee corss_reference_type = 'SCC14' unna item unte data vasthundi.. |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9417
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 3:01 pm: |
|
thanks gochesh...aagu chostha |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 60095
Registered: 07-2004
Posted From: 148.168.127.10
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 2:48 pm: |
|
idhi try chesi choodu....
SELECT msi.inventory_item_id, msi.organization_id, msi.segment1 bom_printed,
msi.description, msi.attribute1 on_counter_date,
msi.attribute2 program_no, msi.attribute12 upc_no,
msi.attribute5 retail_price,
NVL (bbom.alternate_bom_designator, '-') alternate,
NVL (mir.revision, 0) revision,
Case when mcr.cross_reference_type = 'SCC14' then mcr.cross_reference else mcr_alias.cross_reference end "cross_reference"
FROM mtl_system_items msi join mtl_parameters mp on msi.organization_id = mp.organization_id
join mtl_item_revisions mir on msi.inventory_item_id = mir.inventory_item_id
join bom_bill_of_materials bbom on bbom.assembly_item_id = msi.inventory_item_id AND bbom.organization_id = msi.organization_id
join mtl_cross_references mcr on msi.inventory_item_id = mcr.inventory_item_id and mcr.cross_reference_type = 'SCC14'
join mtl_cross_references mcr_alias on msi.inventory_item_id = mcr_alias.inventory_item_id and mcr_alias.cross_reference_type <> 'SCC14'
WHERE mp.organization_code = 'CUS'
AND msi.inventory_item_id = :bom_number
AND msi.organization_id = mir.organization_id
AND NVL (UPPER (RTRIM (bbom.alternate_bom_designator)), '-') = NVL (UPPER (RTRIM (:alt_bom)), '-')
AND NVL (mir.revision, 0) =
(SELECT NVL (MAX (NVL (:item_revision, mir2.revision)), 0)
FROM mtl_item_revisions mir2
WHERE mir2.revision < NVL (:item_revision, 'ZZZ')
AND mir2.inventory_item_id = :bom_number
AND mir2.organization_id = msi.organization_id)
Bewarse Legend Of The Year 2008 Award winner
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9415
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 2:38 pm: |
|
avvaledu gochesh...aadu ekkada aduguthado ani IM ki koda login avvatam ledu office daniki..aadu phone chesi message pettadu inka emaindi ani..kiki..
rendu tables join cheyyocha...adelagaa...aagu chostha.. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 60094
Registered: 07-2004
Posted From: 148.168.127.10
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 2:34 pm: |
|
hemesh,ee froblem inkaa resolve avvaledhaa....
same table ni two times join cheseyyi...workout avudi....
Bewarse Legend Of The Year 2008 Award winner
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9411
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, April 07, 2009 - 2:31 pm: |
|
 |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9350
Registered: 06-2004
Posted From: 75.138.195.125
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 31, 2009 - 11:03 pm: |
|
sarele nayakesh...free unnappude chodu.nenu ee roju office lo 10:45 varaku unna..1099's electrinic file pampesam IRS ki.. |
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 13028
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 31, 2009 - 10:58 pm: |
|
 time dorakala hemu mayya office lo bend thesthunnaru
hasta la victoria siempre
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9348
Registered: 06-2004
Posted From: 75.138.195.125
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 31, 2009 - 10:49 pm: |
|
 |
Prasanth
Bewarse Legend
Username: Prasanth
Post Number: 34968
Registered: 03-2004
Posted From: 203.200.218.58
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 31, 2009 - 6:07 am: |
|
nenu devuDni...!
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9339
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 9:02 pm: |
|
sare nayakesh |
Onlymovies
Yavvanam Kaatesina Bewarse
Username: Onlymovies
Post Number: 1733
Registered: 01-2009
Posted From: 69.250.79.54
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:34 pm: |
|
mari ganta nunchi taagutoone vunnav... |
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12944
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:34 pm: |
|
mandu naku ekkuva avvadam yendi 
hasta la victoria siempre
|
Onlymovies
Yavvanam Kaatesina Bewarse
Username: Onlymovies
Post Number: 1732
Registered: 01-2009
Posted From: 69.250.79.54
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:33 pm: |
|
Nayak baa emitadi.. mandekkuvayyindaa? |
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12943
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:32 pm: |
|
bewarse section ki rananukunnava ralenuanukunnava
hasta la victoria siempre
|
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12942
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:32 pm: |
|
US lo 4 yrs veteran ni nannu parichayam chesukokunda bewarse section lo padi thiruguthunnava
hasta la victoria siempre
|
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12940
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:27 pm: |
|
muzic miya US lo ekkada undedi
hasta la victoria siempre
|
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12939
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:24 pm: |
|
peda baa ekkadunnadu
hasta la victoria siempre
|
Musicfan
Bewarse Legend
Username: Musicfan
Post Number: 13774
Registered: 05-2004
Posted From: 68.43.246.110
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:23 pm: |
|
Onlymovies:taagina taruvata burra pani cheyyatam ledaa
ekkuva satires veyyaku,, unna help kooda cheyyadu |
Onlymovies
Yavvanam Kaatesina Bewarse
Username: Onlymovies
Post Number: 1731
Registered: 01-2009
Posted From: 69.250.79.54
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:22 pm: |
|
//hemu mama repu chepthale
nayak baa.. taagina taruvata burra pani cheyyatam ledaa |
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12936
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:21 pm: |
|
hemu mama repu chepthale
hasta la victoria siempre
|
Onlymovies
Yavvanam Kaatesina Bewarse
Username: Onlymovies
Post Number: 1729
Registered: 01-2009
Posted From: 69.250.79.54
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:18 pm: |
|
'//em peekala ippati daaka..kiki.
 |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9338
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:17 pm: |
|
Onlymovies:evadu swami ilanti Q lu adigedi ninnu..
evado manager mama...chala polite ga adugutha...monday varaku time adagana ani friday adiga..em peekala ippati daaka..kiki. |
Musicfan
Bewarse Legend
Username: Musicfan
Post Number: 13765
Registered: 05-2004
Posted From: 68.43.246.110
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:06 pm: |
|
gochesh nuvvu kooda mandu kotte batch lo join ayyavaa.. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 59864
Registered: 07-2004
Posted From: 24.229.138.244
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:03 pm: |
|
Bewarse Legend Of The Year 2008 Award winner
|
Onlymovies
Yavvanam Kaatesina Bewarse
Username: Onlymovies
Post Number: 1723
Registered: 01-2009
Posted From: 69.250.79.54
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 8:02 pm: |
|
// vadu roju adugutha untadu nannu..nenemo repu repu ani postpone chestha vasthunna naa valla kaka..
evadu swami ilanti Q lu adigedi ninnu..
 |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9337
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:58 pm: |
|
ammayya ardamaindi annamata ayithe... vadu roju adugutha untadu nannu..nenemo repu repu ani postpone chestha vasthunna naa valla kaka.. |
Musicfan
Bewarse Legend
Username: Musicfan
Post Number: 13759
Registered: 05-2004
Posted From: 68.43.246.110
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:53 pm: |
|
Ravanabrahma: oka sql question
idi question laga ledu project laga undi |
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12933
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:53 pm: |
|
thinkinggg
hasta la victoria siempre
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9336
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:52 pm: |
|
baa..ardam kaaleda.. |
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12932
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:51 pm: |
|
hasta la victoria siempre
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9333
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:49 pm: |
|
baa idi baa requirement.
mtl_cross_references mcr ee table ni add chesanu baa from tables list lo..endukante okadu emani adigadu anta..cross_reference_type kanaka
'SCC14' ayithe cross_reference value display cheyyi oka column lo annadu..
reference_type 'SCC14' kakapothe kanaka null display cheyyali aa item ki. so aa item type 'SCC14' lo undochu or 'Worldwide' lonu undochu annamata. oka vela aa item renditlo undi anuko...manam oka 'SCC14' ee thesukovali..endukante final report lo manam oka row ne display chesthunnam aa item ki...
inka konni items ki 'SCC14' type undadu..kaani 'World wide' and 'US' ala undochu..appudu oka row nee display chesi aa item ki..cross_reference value null display cheyyali???
elaa |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9332
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:43 pm: |
|
yaa ala rakodadu...naku anni ravali..kaani cross_reference_type 'SCC14' ayithe cross_reference value display cheyyali aa inventory_id ki..oka vela more than one inventory_id unte kanaka table b lo just only one ee thesukovali either for type 'SCC14'. oka vela 'SCC14' type lekapothe kanaka just null display cheyyali adi koda one row ee display cheyyali aa inventory_id ki |
Onlymovies
Yavvanam Kaatesina Bewarse
Username: Onlymovies
Post Number: 1711
Registered: 01-2009
Posted From: 69.250.79.54
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:41 pm: |
|
bammam mayya prashntam ga raayi requirements.. naya baa bayapettadani kangaru ga rayaku.. |
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12931
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:40 pm: |
|
a.inventory_id = b.inventory_id and
b.reference_type = 'SCC14'
ante only SCC14 inventory items vasthayiii
ikkada nunchi cheppu
hasta la victoria siempre
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9331
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:39 pm: |
|
ok inka clear ga cheptha aagu mama... |
Onlymovies
Yavvanam Kaatesina Bewarse
Username: Onlymovies
Post Number: 1709
Registered: 01-2009
Posted From: 69.250.79.54
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:36 pm: |
|
//requirements sariga cheppu
Nayak.. papam bammam mayyani enduku bhayapedataav
 |
Nayakudu
Bewarse Legend
Username: Nayakudu
Post Number: 12930
Registered: 05-2005
Posted From: 24.117.13.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:35 pm: |
|
requirements sariga cheppu
hasta la victoria siempre
|
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9330
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:35 pm: |
|
kani ekkada problem ante
AND mcr.cross_reference_type(+) = 'SCC14'
icha kabatti cross_reference_type = 'SCC14' leni items ravatam ledu report lo  naaku avi koda raavali kani cross_reference value null undali...elaa |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9329
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:34 pm: |
|
nenu raasina query idi
SELECT msi.inventory_item_id,
msi.organization_id,
msi.segment1 bom_printed,
msi.description,
msi.attribute1 on_counter_date,
msi.attribute2 program_no,
msi.attribute12 upc_no,
msi.attribute5 retail_price,
NVL(bbom.alternate_bom_designator,'-') Alternate,
NVL(mir.revision,0) Revision,
decode(mcr.cross_reference_type, 'SCC14', mcr.cross_reference, NULL) cross_reference
FROM mtl_system_items msi,
mtl_parameters mp,
mtl_item_revisions mir,
bom_bill_of_materials bbom,
mtl_cross_references mcr
WHERE msi.organization_id = mp.organization_id
AND mp.organization_code = 'CUS'
AND msi.inventory_item_id = :bom_number
AND msi.inventory_item_id = mir.inventory_item_id
AND msi.inventory_item_id(+) = mcr.inventory_item_id
AND mcr.cross_reference_type(+) = 'SCC14'
AND msi.organization_id = mir.organization_id
AND NVL(UPPER(RTRIM(bbom.alternate_bom_designator)),'-') = NVL(UPPER(RTRIM(:alt_bom)),'-')
AND bbom.assembly_item_id = msi.inventory_item_id
AND bbom.organization_id = msi.organization_id
AND NVL(mir.revision,0)= (
SELECT NVL( max( NVL(:item_revision, mir2.revision)), 0)
FROM mtl_item_revisions mir2
WHERE mir2.revision < NVL(:item_revision,'ZZZ' )
AND mir2.inventory_item_id = :bom_number
AND mir2.organization_id = msi.organization_id ) |
Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma
Post Number: 9328
Registered: 06-2004
Posted From: 65.196.167.82
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 30, 2009 - 7:31 pm: |
|
naaku table a, b unnay..
a lo inventory_id undi..
ayithe b lo columns inventory_id, reference_type and cross_reference unnay..
ippudu nenu b.cross_reference display cheyyali..when reference_type = 'SCC14' ayinapudu...otherwise dont display..ippudu naku problem entante..
oka inventor_item_id tho two rows undochu with cross_reference_type = 'SCC14' or 'Worldwide'
But it should check for only 'SCC14' inka vere emunna emi display cheyyakodadu..kani ippudu 2 rows unnay kabatti okasari cross_reference isthundi and inkokasari null vasthundi..ala raakodadu...SCC14 unte okasare raavali...
and inkoka problem entante konni inventory_id lu assala 'SCC14' undav..appudu vaatini assala okasari check chesi just oka row display anthe with null value for reference_value...ela raayali..naku antha gandara golam ga undi... |
Archives - 2009