Order Management (OM) Product Categories Query EBS

Order Management (OM) PRODUCT CATEGORIES Query 

SELECT --MC.CONCATENATED_SEGMENTS  ,
MC.SEGMENT1 CAT_1 ,
MC.SEGMENT2 CAT_2 ,
MC.SEGMENT3 CAT_3,
MSI.SEGMENT1 PART# ,
CATEGORY_SET_NAME,
MP.ORGANIZATION_CODE ,
MIC.CREATION_DATE,
MIC.LAST_UPDATE_DATE,
MCS.CATEGORY_SET_ID||'~'||MC.CATEGORY_ID INV_CAT2_ID,
MSI.INVENTORY_ITEM_ID||'~'||MSI.ORGANIZATION_ID,
MIC.LAST_UPDATE_DATE ITEM_UPDATE_DT,
MSI.LAST_UPDATE_DATE SYSTEMS_UPDATE_DT
FROM
apps.MTL_CATEGORIES_B MC,
apps.MTL_ITEM_CATEGORIES MIC,
apps.MTL_SYSTEM_ITEMS_B MSI ,
apps.MTL_CATEGORY_SETS MCS,
apps.MTL_PARAMETERS MP
WHERE MIC.CATEGORY_ID     = MC.CATEGORY_ID
AND MIC.ORGANIZATION_ID   = MSI.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MCS.CATEGORY_SET_ID   = MIC.CATEGORY_SET_ID
AND MSI.SEGMENT1 in ('6047901')
AND MIC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CATEGORY_SET_NAME   ='PRODUCT'
AND MP.ORGANIZATION_CODE  = '100'

Connecting two servers using SSH public keys.

Creating shake hand between servers using SSH public keys.

 

Use the below method to generate Public keys:

On source host server:

Goto to user directory

    cd ~

    mkdir .ssh

    chmod 700 .ssh

    cd .ssh

Execute the below command

 

/usr/local/bin/ssh-keygen -t rsa -b 1024(or) ssh-keygen -t rsa -b 1024

cat id_rsa.pub

 copy contents of id_rsa.pub (file)

On destination host server:

Goto to user directory 

    cd ~

    mkdir .ssh

    chmod 700 .ssh

    cd .ssh

    vi authorized_keys

Paste contents of id_rsa.pub  into authorized keys (to which ever connecting server)
 

chmod 600 authorized_keys --(don’t miss this permission, this should be and must be 600)

After completion of above steps execute below command from destination host:

ssh xyz.alpha.com

Till Next time..:)