0% found this document useful (0 votes)
332 views17 pages

Oracle Apps SQL Queries

The document contains details of various programs and their configurations for an ERP system implementation. It lists many program names prefixed with abbreviations for different applications and functions like BOM, QA, WIP, INV etc. and specifies parameters like application short name and concurrent program name for loading each program configuration using FNDLOAD.

Uploaded by

vvijay05
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
332 views17 pages

Oracle Apps SQL Queries

The document contains details of various programs and their configurations for an ERP system implementation. It lists many program names prefixed with abbreviations for different applications and functions like BOM, QA, WIP, INV etc. and specifies parameters like application short name and concurrent program name for loading each program configuration using FNDLOAD.

Uploaded by

vvijay05
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Honda Amaze Mileage Chevrolet Sail Pictures Tata Indigo eCS MPV GO+, Go-Hutch Back organization access

in inventory to assign org window to responsibility gdivya08@[Link] 833240430 864240033 TO_CHAR(TO_DATE(:P_DATE,'YYYY/MM/DD HH24:MI:SS'),'DD-MON-YYYY'); UAT Putty cd /ebsapps/jmsuat/apps/apps_st/appl . APPSJMSUAT_ebsdrapp2.env . JMSUAT_ebsdrapp2.env 611838811 11i 633842410 R12 R12 Dev: WINSCP Oraapps ora123 (select distinct meaning from fnd_lookups where lookup_type = 'JMS_ORG_ID_MAPPI NG' and lookup_code = 82) sqlldr apps/apps control = 'PFS_INV_ITEM_MASTER_CNV_LDR.ctl' sqlldr apps/apps control = 'PFS_INV_ITEM_REV_CNV_LDR.ctl' FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSPOPRBTM .ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSPOPRBTM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMVERI [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMVE RIFYITM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMVITM [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMVITMX L" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMVITX [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMVITXL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMVUP. ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMVUP" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMEXP. ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMEXP" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMEXPC [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMEXPCM O" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMEXPX [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMEXPXL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMCSTS [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMCSTSI M" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMWIPX [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMWIPXL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMITEM [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMITEM BTM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMITEM [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMITEM USE" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMITEM [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMITEM UXL"

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSTRLOTUP .ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSTRLOTUP" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMPCM. ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMPCM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMPCW. ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMPCW" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMSTRU [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMSTRUC T" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMWIPU [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMWIPUS E" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMWIPC [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMWIPCM O" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMWIPX [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSBOMWIPXL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTDOBT [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTDOBTM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTBOLX [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTBOLXL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTBOLM [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTBOLMI S" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTBOLI [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTBOLIX L" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTBOLI [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTBOLIT M" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTBOLL [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTBOLLI" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTCMOP [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTCMOPI" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTCMI. ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTCMI" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTDO.l dt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTDO" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTLOTL .ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTLOTL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTLOTL [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTLOTLV 2" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTISDE [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTISDEP" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTPLIS [Link] PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTPLIST" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMOCS.l dt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSOMOCS" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMORPER .ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSOMORPER" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSONTINV. ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSONTINV" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMINVXL .ldt PROGRAM APPLICATION_SHORT_NAME="JMS" CONCURRENT_PROGRAM_NAME="JMSOMINVXL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPBTSM [Link] PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMS_BTS_PRO DUCTION" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPDJLC

[Link] PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMS_WIP_DJ_L T" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPJLCR .ldt PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMS_JOB_LOT_T XT" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPMPLB [Link] PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMS_PDN_RECO RD" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPMPLF [Link] PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMSWIPFIL01" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMS_PDN_RE CORD_ME.ldt PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMS_PD N_RECORD_ME" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQABISTR .ldt PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_STR " FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQACFMTT .ldt PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_A_N OQTY" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQACOCFB [Link] PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_B1 _C" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQACOCFA .ldt PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_A" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQACOCB1 .ldt PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_B1" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQACOCB1 [Link] PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_B1 _D" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQACOCB1 [Link] PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_B1 _F" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQACOCB1 [Link] PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_B1 _A"\ FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQACOCB1 [Link] PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_PR_COC_B1 _B" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSCSTCRR. ldt PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMSCSTRU_MIS" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMIWNC .ldt PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMS_NO_BOM_IT EM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMTDP. ldt PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMSLOTDN" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMGRNBT [Link] PROGRAM APPLICATION_SHORT_NAME="INV" CONCURRENT_PROGRAM_NAME="JMS_BTM_INV_ GRN" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMMIL.l dt PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="JMS_OM_INSURED_ LIST" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMSTJBT [Link] PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="JMS_OM_NEW00 3_SALES_JMS_BATAM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMLTSR .ldt PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMSCSTRU" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMOITM .ldt PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMS_ORPHAN_IT EM"

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMBOSBM .ldt PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="JMS_OEXOEITR_ MTH_TEXT" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMCMOPI [Link] PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="JMS_CMO_OM_ PROFORMA_INV_TXT" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMRTR. ldt PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMS_BOM_EXP2" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMMIST .ldt PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMS_BOM_REPOR T_DTL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMSSRB [Link] PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="JMS_013_OM_S S_CUST" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMSSRB [Link] PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="JMS_012_OM_S S_PER" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQAFPSRF .ldt PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_BTM_QA_FPS R_FINAL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSQAFPSR. ldt PROGRAM APPLICATION_SHORT_NAME="QA" CONCURRENT_PROGRAM_NAME="JMS_BTM_QA_FPSR " FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMPACD. ldt PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="JMS_OM_PACKING _DATA_TXT" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSOMBODR. ldt PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="JMS_016_BACKOR DER_DETAIL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPMSL. ldt PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMS_SCHEDULE_L IST" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPFGSS [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_FG_STO CK_TAKE3" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPFGSS [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_FG_STO CK_STATUS" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSCSTCRRP [Link] PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMSCSTRU_PD F" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPFGSS [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_FG_STO CK_STATUS2" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPFGSS .ldt PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_FG_STOCK _SUMMARY" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPPR. ldt PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_PROD_PERF 1" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPPS. ldt PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_PROD_PERF _SUM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPPSD [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMS_PROD_PER F_INV_SUM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPDR. ldt PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_PURCHASE_ DEMAND" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPSOCL

.ldt PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_SALES_OR DER_CAPACITY_LOAD" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPCMOP [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_CMO_PR OD_PERF_SUM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPCFM [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_PCF_MTH LY_USAGES" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPDPL [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_PURCH ASE_DEMAND_PLSQL" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPPSX [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMS_PROD_PER F_SUM_TXT" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPSR. ldt PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSS_PRODUCTIO N_SCHEDULE" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPCMOI [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMS_CMO_FG_S TOCK_STATUS3" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPCMOS [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMS_CMO_FG_S TOCK_STATUS1" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPCMOS [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMS_CMO_FG_S TOCK_STATUS2" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSBOMRNGX [Link] PROGRAM APPLICATION_SHORT_NAME="BOM" CONCURRENT_PROGRAM_NAME="JMS_BOM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPSDC [Link] PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMS_PROD_PE RF_INV_SUM_TXT" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPJLCR [Link] PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMS_JOB_LOT _COMP_TXT" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPMVTR .ldt PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMS_WIP_MOVE_ TRX" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPWOCL .ldt PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMSWOCOMPLLOT " FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSMRPPPDR .ldt PROGRAM APPLICATION_SHORT_NAME="MRP" CONCURRENT_PROGRAM_NAME="JMSMRPPPDR" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] JMSWIPJLCR [Link] PROGRAM APPLICATION_SHORT_NAME="WIP" CONCURRENT_PROGRAM_NAME="JMS_JOB_LOT _COMP_TXT" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] JMS_ITEM_USE .ldt UPLOAD_MODE=REPLACE CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] JMS_ITEM_USE _BTM.ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] JMS_ITEM_USE _BTM.ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] JMSBOMSTRUCT .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] JMS_BOM_WIP_ [Link] CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] JMS_BOM_VERI FY_ITM_PDF.ldt CUSTOM_MODE = FORCE JMS BOM Verification by Item - PDF FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] JMS_BOM_EXP.

ldt CUSTOM_MODE = FORCE JMS Bill of Material Report FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] [Link] CUSTOM_MODE = FORCE JMS Bill of Material Report (CMO) FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] FY_ITM_TXT.ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] [Link] CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] [Link] CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link]

JMS_BOM_EXP_ JMS_BOM_VERI JMSBOMVERIFY JMSBOMEXPXL. JMSBOMCSTSIM JMSBOMWIPXL. JMSBOMITEMUX JMSTRLOTUP.l JMSBOMWIPUSE JMSBOMWIPEXL JMSPOREQBTM. JMSONTDOBTM. JMSONTBOLITM JMSONTBOLLI. JMSONTCMOPI. [Link] [Link] JMSONTLOTL.l JMSONTLOTLV2 JMSONTISDEP. JMSONTBOLXL. JMSONTBOLIXL JMSONTPLIST. [Link] JMSONTPROINV JMSONTPIPL.l JMSONTROALR. JMSONT5ROLR. JMSOMORPER.l [Link]

CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD [Link] CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD

$FND_TOP/patch/115/import/[Link] JMSWIPBTSMIS $FND_TOP/patch/115/import/[Link] JMSWIPDJLCR. $FND_TOP/patch/115/import/[Link] JMSWIPJLCR.l $FND_TOP/patch/115/import/[Link] JMSWIPMPLBA. $FND_TOP/patch/115/import/[Link] JMSWIPMPLFR. $FND_TOP/patch/115/import/[Link] [Link] $FND_TOP/patch/115/import/[Link] JMSQACFMTT.l $FND_TOP/patch/115/import/[Link] JMSQACOCFBC. $FND_TOP/patch/115/import/[Link] JMSQACOCFA.l $FND_TOP/patch/115/import/[Link] JMSQACOCB1.l $FND_TOP/patch/115/import/[Link] JMSQACOCB1D. $FND_TOP/patch/115/import/[Link] JMSQACOCB1F. $FND_TOP/patch/115/import/[Link] JMSQACOCB1A. $FND_TOP/patch/115/import/[Link] JMSQACOCB1B. $FND_TOP/patch/115/import/[Link] [Link] $FND_TOP/patch/115/import/[Link] JMSBOMIWNC.l $FND_TOP/patch/115/import/[Link] [Link] $FND_TOP/patch/115/import/[Link] JMSSALEPERSU $FND_TOP/patch/115/import/[Link] JMSOMSTJBTM. $FND_TOP/patch/115/import/[Link] JMSBOMLTSR.l $FND_TOP/patch/115/import/[Link] JMSBOMOITM.l $FND_TOP/patch/115/import/[Link] [Link] $FND_TOP/patch/115/import/[Link] JMSBOMIWUT.l $FND_TOP/patch/115/import/[Link] JMSBOMSSRBC. $FND_TOP/patch/115/import/[Link] JMSBOMSSRBP. $FND_TOP/patch/115/import/[Link] JMSQAFPSRF.l $FND_TOP/patch/115/import/[Link] [Link] $FND_TOP/patch/115/import/[Link] JMSOMBOSBM.l $FND_TOP/patch/115/import/[Link] [Link] $FND_TOP/patch/115/import/[Link] [Link]

t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] [Link] CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] t CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] .ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] dt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] t UPLOAD_MODE=REPLACE CUSTOM_MODE = FORCE FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] t - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

JMSMRPFGSSIS JMSMRPFGSSNS [Link] JMSCSTCRRPDF JMSMRPFGSSSS JMSMRPFGSS.l [Link] [Link] JMSMRPPPSDC. [Link] JMSMRPSOCL.l JMSMRPCMOPPS JMSMRPPCFMU. JMSMRPPDPLSQ JMSMRPPPSXL. [Link] JMSMRPCMOIS. JMSMRPCMOSN. JMSMRPCMOSS. JMSBOMRNGXL. JMSMRPPSDCXL JMSWIPMVTR.l JMSWIPJLCRXL JMSWIPWOCL.l [Link] [Link]

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] RPT_QTY_PR [Link] PROFILE PROFILE_NAME="REPORT_QUANTITY_PRECISION" APPLICATION_SHORT_NAME="I NV" $FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] RPT_QTY_PRC.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

WEB ADI: FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/admin/import/[Link] XXPO_ASSGN_SET_I [Link] BNE_INTEGRATORS INTEGRATOR_ASN="XX" INTEGRATOR_CODE="XXPO_ASSGN_SET_INTG " FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/admin/import/[Link] XXPO_SOURCE_RULE _INTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN="XX" INTEGRATOR_CODE="XXPO_SOURCE_RULE_ INTG" FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/[Link] XXPO_ ASSGN_SET_INTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN="XX" INTEGRATOR_CODE="XXPO_ASS GN_SET_INTG" FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/[Link] XXPO_ SOURCE_RULE_INTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN="XX" INTEGRATOR_CODE="XXPO_S OURCE_RULE_INTG" Prog Files: ln -s $FND_TOP/bin/fndcpesr $XXINV_TOP/bin/XX_UPD_ITEM_AVG_CST_RM_FILE PLL: frmcmp_batch Module=PFSAP_PR.pll userid = apps/apps module_type=LIBRARY frmcmp_batch module=PFSAP_PR.pll userid=apps/apps output_file=PFSAP_PR.plx modul e_type=LIBRARY frmcmp_batch module=[Link] userid=apps/apps output_file=[Link] module_ty pe=LIBRARY frmcmp_batch module=PFSAP_INV.pll userid=apps/apps output_file=PFSAP_INV.plx mod ule_type=LIBRARY compile_all=special batch=yes cd $AU_TOP/forms/US frmcmp_batch module=[Link] userid=apps/apps output_file=/u01/VIS/apps/apps_ st/appl/po/12.0.0/forms/US/[Link] module_type=form frmcmp_batch module=[Link] userid=apps/apps output_file=/u01/VIS/apps/app s_st/appl/po/12.0.0/forms/US/[Link] module_type=form ----f60gen module=XXITEMXREF_V1.fmb userid=apps/apps123 module_type=FORM output_ file=/oracle/R12/apps/DVERP/dverpappl/xxinv/11.5.0/forms/US/XXITEMXREF_V1.fmx frmcmp_batch module=[Link] userid=apps/apps output_file=/oracle/R12/SPT/a pps/apps_st/appl/xxpo/12.0.0/forms/US/[Link] module_type=form 7. Form Function -- --------------------FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_WIPCMPP [Link] FUNCTION FUNCTION_NAME="PFS_WIPCMPPK" FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XXPO_PRCOPY .ldt FUNCTION FUNCTION_NAME="XXPO_PRCOPY"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_WIPCMPPK. ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] XXPO_PRCOPY.l dt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE Look ups: FNDLOAD apps/apps123@dverp O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XX _wip_org_loc.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXWIP" LOOKUP_TYPE="PFS AP_DEFAULT_ORG_LOCATOR" FNDLOAD apps/apps123@dverp O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PF S_PO_WORKFLOW.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="PO" LOOKUP_TYPE="PFSAP - PO CUSTOM WORKFLOW" FNDLOAD apps/apps123@dverp O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PF S_ITEM_SOURCE_LEAD_TIME.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXINV" LOOKU P_TYPE="PFSAP_ITEM_SOURCE_LEADTIME_DAY" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] XX_WIP_ORG_LO [Link] UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_PO_WORKFL [Link] UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_PO_MAX_TI [Link] UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] fil e_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME= prod LOOKUP_TYPE= lookup name concurrent: FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XXP26QUOTL [Link] PROGRAM APPLICATION_SHORT_NAME="PFSINV" CONCURRENT_PROGRAM_NAME="XXCROSSOV ER_OPTION_UNITS_RPT" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XX_UPDATE_ ITEM_AVG_COST.ldt PROGRAM APPLICATION_SHORT_NAME="PFSINV" CONCURRENT_PROGRAM_NAM E="XX_UPDATE_ITEM_AVG_COST" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFSAP_OUT_ PR_STATUS.ldt PROGRAM APPLICATION_SHORT_NAME="PFSWIP" CONCURRENT_PROGRAM_NAME="P FSAP_OUT_PR_STATUS" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFSAP_OUT_ PR_STATUS.ldt PROGRAM APPLICATION_SHORT_NAME="PFSINV" CONCURRENT_PROGRAM_NAME="P FSAP_OUT_PR_STATUS" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] XXPO_LINELOC _CONC_TR.ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] XXQUOTPRICEH IST_RPT.ldt CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] XXMASSOQRY_N [Link] CUSTOM_MODE = FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] PFSAP_POXRVR [Link] CUSTOM_MODE = FORCE

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] EM_AVG_COST.ldt FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] EM_COST.ldt FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] CST_UPD.ldt FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] AVG_CST_RM_FILE.ldt FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] _STATUS.ldt CUSTOM_MODE = FORCE Value Sets:

XX_UPDATE_IT XX_UPDATE_IT XXPFSAP_AVG_ XX_UPD_ITEM_ PFSAP_OUT_PR

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.l ct XXP26QUOTLA_val.ldt VALUE_SET FLEX_VALUE_SET_NAME="PFSAP_QUOTATION_REF_CODE" $FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] XXP26QUOTLA_VAL.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE SELECT USER_CONCURRENT_PROGRAM_NAME, [Link], DECODE (a.EXECUTION_METHOD_ CODE, 'I', 'PL/SQL Stored Procedure', 'P','Oracle Reports', 'L','SQL*Loader')EXECUTION_METHOD_CO DE , EXECUTABLE_NAME,EXECUTION_FILE_NAME FROM FND_CONCURRENT_PROGRAMS_VL a, FND_EXECUTABLES_Vl b WHERE 1=1 AND USER_CONCURRENT_PROGRAM_NAME like 'PFSSG P2 Item Demand and Supply Trend(Order Received)' and a.EXECUTABLE_ID=b.EXECUTABLE_ID; XXPFSAP_PURCHASE_ITEM_DTL_NEW select * from FND_CONCURRENT_PROGRAMS_VL where 1=1 AND upper(USER_CONCURRENT_ PROGRAM_NAME) LIKE upper('%PFSAP%P23%Purchasable %Report%');

ldt files:

1. Lookups -- ------------FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_L [Link] FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TY PE" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_PRICE _DIS.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="PFSONT" LOOKUP_TYPE="PFSAP_PRIC E_DISCOUNT_DISPLAY" PFSAP_PRICE_DISCOUNT_DISPLAY FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_PRICE_DIS .ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

2. Concurrent Program -- ----------------------------FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_ [Link] PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCU RRENT_PROGRAM" FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_ [Link] PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCU RRENT_PROGRAM" FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_CP .ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

3. Profile -- --------FNDLOAD apps/apps123 O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFSSG_I NV_ADDN.ldt PROFILE PROFILE_NAME="PFSSG_INV_ADDN" APPLICATION_SHORT_NAME="XXONT" FNDLOAD apps/apps123 O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFSSG_I NV_COST.ldt PROFILE PROFILE_NAME="PFSSG_INV_COST" APPLICATION_SHORT_NAME="XXONT" FNDLOAD apps/apps123 O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFSSG_I NV_PRICE.ldt PROFILE PROFILE_NAME="PFSSG_INV_PRICE" APPLICATION_SHORT_NAME="XXON T" FNDLOAD apps/apps123 O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFSSG_I NV_DEMAND.ldt PROFILE PROFILE_NAME="PFSSG_INV_DEMAND" APPLICATION_SHORT_NAME="XX ONT" FNDLOAD apps/apps123 O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFSSG_Q _ONLY.ldt PROFILE PROFILE_NAME="PFSSG_Q_ONLY" APPLICATION_SHORT_NAME="XXONT"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFSSG_INV_ADDN.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE $FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFSSG_INV_COST.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE $FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFSSG_INV_PRICE.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE $FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFSSG_INV_DEMAND.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE $FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFSSG_Q_ONLY.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE 4. Request Set and Link -- -----------------------------FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_ [Link] REQ_SET REQUEST_SET_NAME='REQUEST_SET_NAME' FNDLOAD apps/apps123 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] $v_conc name"_LINK.ldt" REQ_SET_LINKS REQUEST_SET_NAME=$v_concname FNDLOAD apps/apps123 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] $v_conc [Link] REQ_SET APPLICATION_SHORT_NAME=$v_shortname REQUEST_SET_NAME=$v_concnam e FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_R

[Link] UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_R [Link] UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] FNDRSSUB106 [Link] FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] FNDRSSUB106 9_LINK.ldt 5. FND Message -- --------------------FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_M [Link] FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUST" MESSAGE_NAME="MESSAGE_N AME%"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_MES [Link] UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

6. D2K FORMS -- -----------------$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] t XX_CUSTOM_FRM.ldt FORM FORM_NAME="FORM_NAME"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_FRM.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

7. Form Function -- --------------------FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_F [Link] FUNCTION FUNCTION_NAME="FORM_FUNCTION_NAME"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_FUNC.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

8. Alerts -- --------FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/[Link] XX_CUSTOM_ALR.l dt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX - Alert Name" FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/[Link] XX_P3_AQN_SUP.l dt ALR_ALERTS APPLICATION_SHORT_NAME=ALR ALERT_NAME="PFSAP P3 Supplier AQN's" FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/[Link] XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/[Link] XX_P3_AQN_SUP.ldt CUSTOM_MODE=FORCE

9. Value Set -- -------------$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.l ct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

10. Data Definition and Associated Template --- ---------------------------------------------------------FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $XDO_TOP/patch/115/import/[Link] t XX_CUSTOM_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURC E_CODE='XX_SOURCE_CODE' TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='XX_SOURCE_CO DE'

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/[Link] X X_CUSTOM_DD.ldt

11. DATA_TEMPLATE (Data Source .xml file) --- ---------------------------------------------------------java [Link] DOWNLOAD -DB_USERNAME apps -DB_PASSWORD a pps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PO RT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DAT A_TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/[Link] -LOG_FILE $LOG_FILE_NAME

java [Link] UPLOAD -DB_USERNAME apps -DB_PASSWORD app s -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT =XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_ TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DA TA_FILE_NAME.xml -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $L OG_FILE_NAME

12. RTF TEMPLATE (Report Layout .rtf file) --- ------------------------------------------------------java [Link] DOWNLOAD -DB_USERNAME apps -DB_PASSWORD a pps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PO RT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEM PLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -TERRITORY US lct_FILE $XDO_TOP/patch/115/import/[Link] -LOG_FILE $LOG_FILE_NAME

java [Link] UPLOAD -DB_USERNAME apps -DB_PASSWORD app s -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT =XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NA [Link] -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NA

ME 14. Form Personalization Download -specific form< /STRONG> FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] <[Link]> FND_FORM_CUSTOM_RULES form_name=<form name>< /FONT> Download -for all personalizations< /FONT> FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] <[Link]> FND_FORM_CUSTOM_RULES function_name=<function name>< /FONT> FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_GET_IN SPEC_STATUS.ldt FND_FORM_CUSTOM_RULES form_name=WIPTXSFM FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_DEFAUL T_SUB_INV.ldt FND_FORM_CUSTOM_RULES form_name=WIPTXCMP FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_GET_INSP EC_STATUS.ldt FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_DEFAULT_ SUB_INV.ldt FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_QTY_VA [Link] FND_FORM_CUSTOM_RULES form_name=WIPTXMAT FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_QTY_VALD .ldt FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_PO_COO _REQ.ldt FND_FORM_CUSTOM_RULES form_name=RCVRCERC FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_PO_COO_R [Link] FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_ENGFDE [Link] FND_FORM_CUSTOM_RULES form_name=ENGFDECN FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_ENGFDECN .ldt FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_FNDATT [Link] FND_FORM_CUSTOM_RULES form_name=FNDATTCH FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_FNDATTCH .ldt FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link] PFS_QTY_VA [Link] FND_FORM_CUSTOM_RULES form_name=WIPTXMAT FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] PFS_QTY_VALD .ldt 13. To FNDLOAD Oracle Descriptive Flexfields $FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.l ct PFS_OE_ORDER_TYPES.ldt DESC_FLEX APPLICATION_SHORT_NAME=ONT DESCRIPTIVE_FLEXF IELD_NAME='OE_ORDER_TYPES' $FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.l ct PFS_WSH_NEW_DELIVERIES.ldt DESC_FLEX APPLICATION_SHORT_NAME=WSH DESCRIPTIVE_F LEXFIELD_NAME='WSH_NEW_DELIVERIES' $FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.l ct PFS_MTL_TXN_REQUEST_HEADERS.ldt DESC_FLEX APPLICATION_SHORT_NAME=INV DESCRIPT

IVE_FLEXFIELD_NAME='MTL_TXN_REQUEST_HEADERS' $FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.l ct PFS_MTL_TXN_REQUEST_LINES.ldt DESC_FLEX APPLICATION_SHORT_NAME=INV DESCRIPTIV E_FLEXFIELD_NAME='MTL_TXN_REQUEST_LINES' $FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.l ct PFS_MTL_MATERIAL_TRANSACTIONS.ldt DESC_FLEX APPLICATION_SHORT_NAME=INV DESCRI PTIVE_FLEXFIELD_NAME='MTL_MATERIAL_TRANSACTIONS' FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] _TYPES.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] [Link] UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] REQUEST_HEADERS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] REQUEST_LINES.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/[Link] RIAL_TRANSACTIONS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE ====================================================== 11i OS pwd ([Link]) Username : appt1 Pwd : appt1 R12 OS pwd ([Link]) Username : oraapps Pwd : ora123 ================================================================== R12 TEST : [Link] R12 Vision : [Link] 11i Test : [Link] 11i New Test : [Link] ( userid/pwd:KA_IOM/mis1234) 11i PROD : [Link] ( userid/pwd:KA_IOM/mis1234) =============================================================================== [Link]= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=[Link])(PORT=1522)) (CONNECT_DATA= (SID=TEST1) ) ) VISR12= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=[Link])(PORT=1521)) (CONNECT_DATA= (SID=VIS) ) ) TESTR12= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=[Link])(PORT=1527)) (CONNECT_DATA= PFS_OE_ORDER PFS_WSH_NEW_ PFS_MTL_TXN_ PFS_MTL_TXN_ PFS_MTL_MATE

(SID=JMSDEV) ) ) -----To know locked tables-------------select a.SESSION_ID,[Link]#,a.ORACLE_USERNAME, a.OS_USER_NAME, [Link] "OBJECT OWNER", B.OBJECT_NAME,B.OBJECT_TYPE,a.LOCKED_MODE from (select OBJECT_ID, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, LOCKED_MODE from V $LOCKED_OBJECT) a, (select OBJECT_ID, OWNER, OBJECT_NAME,OBJECT_TYPE from DBA_OBJECTS) B, gv$session c where a.OBJECT_ID=B.OBJECT_ID and a.SESSION_ID=[Link]; --alter system kill session '3768,17542' immediate; ------------- To find attached request group and responsibility for concurrent p rograms-------------SELECT REQUEST_GROUP_NAME,REQUEST_GROUP_ID FROM FND_REQUEST_GROUPS WHERE REQUEST_GROUP_ID IN ( SELECT FRG.REQUEST_GROUP_ID FROM FND_REQUEST_GROUP _UNITS FRG,FND_CONCURRENT_PROGRAMS_VL fcp WHERE FRG.REQUEST_UNIT_ID = [Link] _PROGRAM_ID AND FCP.USER_CONCURRENT_PROGRAM_NAME = 'JM S Closing Stock Summary Report'); select RESPONSIBILITY_NAME from FND_RESPONSIBILITY_VL where REQUEST_GROUP_ID I N (297,124); T2463780 9963128601 ravindra reddy 9490782439 9790792837 VENUGOPAL 9642939622 sri anitha.ani66@[Link] [Link]@[Link],ravindra6789@[Link],[Link]@[Link],prasad reddi@[Link], [Link]@[Link],[Link]@[Link],[Link] uduru@[Link], [Link]@[Link],[Link]@[Link],MASTAN543@[Link],[Link] nareddy@[Link]

You might also like