eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_RULE_MIGRATE dependencies on OKS_RULE_UPGRADE

Line 28660: ' FROM OKS_RULE_UPGRADE '||

28656: L_STMT := ' SELECT RGP_ID ,CLE_ID , CHR_ID, DNZ_CHR_ID ' ||
28657: ' ,SUM(COUNT(*)) OVER (ORDER BY RGP_ID ROWS UNBOUNDED PRECEDING) '||
28658: -- ' ,DECODE(RULE_INFORMATION_CATEGORY,''SLL'' ,''SLL'',''CVR'' ,''CVR'', ''RCN'' ,''RCN'',''RSN'',''RSN'',''ALL'') '||
28659: ' ,RIC_CODE , Major_version'||
28660: ' FROM OKS_RULE_UPGRADE '||
28661: ' WHERE RGP_ID BETWEEN :1 AND :2 '||
28662: ' GROUP BY RGP_ID , CLE_ID, CHR_ID, DNZ_CHR_ID '||
28663: -- ' ,DECODE(RULE_INFORMATION_CATEGORY,''SLL'' ,''SLL'',''CVR'' ,''CVR'', ''RCN'' ,''RCN'',''RSN'', ''RSN'' ,''ALL'') ' ;
28664: ' ,RIC_CODE,Major_version ';

Line 28883: FROM OKS_RULE_UPGRADE OKS

28879: IF L_DELETE_RGP_ID.COUNT > 500 THEN
28880: BEGIN
28881: FORALL X IN L_DELETE_COUNT.FIRST..L_DELETE_COUNT.LAST
28882: DELETE /*+ PARALLEL(OKS) */
28883: FROM OKS_RULE_UPGRADE OKS
28884: WHERE RGP_ID = L_DELETE_RGP_ID(X)
28885: AND RIC_CODE = L_DELETE_CATEGORY(X)
28886: AND ROWNUM < L_DELETE_COUNT(X);
28887:

Line 28910: FROM OKS_RULE_UPGRADE OKS

28906: IF L_DELETE_RGP_ID.COUNT > 0 THEN
28907: BEGIN
28908: FORALL X IN L_DELETE_COUNT.FIRST..L_DELETE_COUNT.LAST
28909: DELETE /*+ PARALLEL(OKS) */
28910: FROM OKS_RULE_UPGRADE OKS
28911: WHERE RGP_ID = L_DELETE_RGP_ID(X)
28912: AND RIC_CODE = L_DELETE_CATEGORY(X)
28913: AND ROWNUM < L_DELETE_COUNT(X);
28914:

Line 38750: FROM OKS_RULE_UPGRADE RGP;

38746: MAX(RGP.RGP_ID) MAXID,
38747: AVG(RGP.RGP_ID) AVGID,
38748: STDDEV(RGP.RGP_ID) STDID,
38749: COUNT(*) TOTAL
38750: FROM OKS_RULE_UPGRADE RGP;
38751:
38752: L_GET_UPGRADE_INFO_REC L_GET_UPGRADE_INFO%ROWTYPE;
38753:
38754: CURSOR L_GET_REPROCESS_INFO IS

Line 38763: --- Code to prep the data in OKS_RULE_UPGRADE --

38759: STDDEV(RGP.ID) STDID,
38760: COUNT(*) TOTAL
38761: FROM OKS_RULE_REPROCESS RGP;
38762:
38763: --- Code to prep the data in OKS_RULE_UPGRADE --
38764: L_LINE_ID L_NUM_TBL ;
38765: L_DNZ_CHR_ID L_NUM_TBL ;
38766: L_CUST_PO_NUMBER L_CHR_TBL;
38767: L_CUST_PO_NUMBER_REQ_YN L_CHR_TBL;

Line 38777: FROM OKS_RULE_UPGRADE UPG

38773: , UPG.DNZ_CHR_ID
38774: , OKCH.CUST_PO_NUMBER
38775: , OKCH.CUST_PO_NUMBER_REQ_YN
38776: , OKCH.PRICE_LIST_ID
38777: FROM OKS_RULE_UPGRADE UPG
38778: , OKC_K_HEADERS_B OKCH
38779: WHERE UPG.RIC_CODE = 'LIN'
38780: AND NOT EXISTS ( SELECT 1 FROM OKS_K_LINES_B OKS1
38781: WHERE OKS1.CLE_ID = UPG.RGP_ID )

Line 38791: SELECT /+ INDEX_FFS( l OKS_RULE_UPGRADE_NU1) /

38787: COUNT(*)
38788: FROM OKS_RULE_REPROCESS l;
38789:
38790: CURSOR L_UPGRADE_CNT_CSR IS
38791: SELECT /*+ INDEX_FFS( l OKS_RULE_UPGRADE_NU1) */
38792: COUNT(*)
38793: FROM OKS_RULE_UPGRADE l;
38794:
38795:

Line 38793: FROM OKS_RULE_UPGRADE l;

38789:
38790: CURSOR L_UPGRADE_CNT_CSR IS
38791: SELECT /*+ INDEX_FFS( l OKS_RULE_UPGRADE_NU1) */
38792: COUNT(*)
38793: FROM OKS_RULE_UPGRADE l;
38794:
38795:
38796: TYPE L_CSR IS REF CURSOR;
38797: L_UPGRD_CSR L_CSR ;

Line 38831: --- Added the following code to analyze the OKS_RULE_UPGRADE table ---

38827:
38828: BEGIN
38829:
38830: ----------------------------------------------------------------------------------------------------
38831: --- Added the following code to analyze the OKS_RULE_UPGRADE table ---
38832: ----------------------------------------------------------------------------------------------------
38833: FND_STATS.Gather_Table_Stats(OWNNAME =>'OKS',
38834: TABNAME =>'OKS_RULE_UPGRADE',
38835: PERCENT => 20,

Line 38834: TABNAME =>'OKS_RULE_UPGRADE',

38830: ----------------------------------------------------------------------------------------------------
38831: --- Added the following code to analyze the OKS_RULE_UPGRADE table ---
38832: ----------------------------------------------------------------------------------------------------
38833: FND_STATS.Gather_Table_Stats(OWNNAME =>'OKS',
38834: TABNAME =>'OKS_RULE_UPGRADE',
38835: PERCENT => 20,
38836: RETCODE => l_return_code,
38837: ERRBUF => l_error_buffer);
38838:

Line 38872: FROM OKS_RULE_UPGRADE UPG1

38868: ,SYSDATE
38869: ,1
38870: ,SYSDATE
38871: ,2003
38872: FROM OKS_RULE_UPGRADE UPG1
38873: WHERE UPG1.RIC_CODE = 'HDR'
38874: AND NOT EXISTS ( SELECT 1
38875: FROM OKC_RULE_GROUPS_B RGP
38876: , OKC_RULES_B RULE

Line 38884: DELETE FROM OKS_RULE_UPGRADE

38880: AND NOT EXISTS ( SELECT 1 FROM OKS_K_HEADERS_B OKSHI
38881: WHERE OKSHI.CHR_ID = UPG1.DNZ_CHR_ID )
38882: GROUP BY DNZ_CHR_ID;
38883:
38884: DELETE FROM OKS_RULE_UPGRADE
38885: WHERE RIC_CODE = 'HDR';
38886:
38887:
38888: DELETE /*+ PARALLEL(UPG1) */

Line 38889: FROM OKS_RULE_UPGRADE UPG1

38885: WHERE RIC_CODE = 'HDR';
38886:
38887:
38888: DELETE /*+ PARALLEL(UPG1) */
38889: FROM OKS_RULE_UPGRADE UPG1
38890: WHERE UPG1.RIC_CODE = 'LIN'
38891: AND EXISTS ( SELECT /*+ INDEX_FFS( UPG2 OKS_RULE_UPGRADE_NU2) */ 1 FROM OKS_RULE_UPGRADE UPG2
38892: WHERE UPG2.RGP_ID = UPG1.RGP_ID
38893: AND UPG2.RIC_CODE = 'ALL' );

Line 38891: AND EXISTS ( SELECT /+ INDEX_FFS( UPG2 OKS_RULE_UPGRADE_NU2) / 1 FROM OKS_RULE_UPGRADE UPG2

38887:
38888: DELETE /*+ PARALLEL(UPG1) */
38889: FROM OKS_RULE_UPGRADE UPG1
38890: WHERE UPG1.RIC_CODE = 'LIN'
38891: AND EXISTS ( SELECT /*+ INDEX_FFS( UPG2 OKS_RULE_UPGRADE_NU2) */ 1 FROM OKS_RULE_UPGRADE UPG2
38892: WHERE UPG2.RGP_ID = UPG1.RGP_ID
38893: AND UPG2.RIC_CODE = 'ALL' );
38894: COMMIT;
38895:

Line 38897: FROM OKS_RULE_UPGRADE UPG1

38893: AND UPG2.RIC_CODE = 'ALL' );
38894: COMMIT;
38895:
38896: DELETE /*+ PARALLEL(UPG1) */
38897: FROM OKS_RULE_UPGRADE UPG1
38898: WHERE UPG1.RIC_CODE = 'LIN'
38899: AND EXISTS ( SELECT 1 FROM OKS_K_LINES_B OKS
38900: WHERE OKS.CLE_ID = UPG1.RGP_ID );
38901: COMMIT;

Line 38905: FROM OKS_RULE_UPGRADE UPG1

38901: COMMIT;
38902:
38903:
38904: DELETE /*+ PARALLEL(UPG1) */
38905: FROM OKS_RULE_UPGRADE UPG1
38906: WHERE UPG1.RIC_CODE = 'LIN'
38907: AND NOT EXISTS ( SELECT 1 FROM OKC_K_LINES_B OKC
38908: WHERE OKC.ID = UPG1.RGP_ID );
38909: COMMIT;

Line 38973: DELETE FROM /+ PARALLEL(UPG) / OKS_RULE_UPGRADE UPG

38969: SET PRICE_LIST_ID = L_PRICE_LIST_ID(I)
38970: WHERE ID = L_LINE_ID(I);
38971:
38972: FORALL I IN L_LINE_ID.FIRST..L_LINE_ID.LAST
38973: DELETE FROM /*+ PARALLEL(UPG) */ OKS_RULE_UPGRADE UPG
38974: WHERE RGP_ID = L_LINE_ID(I)
38975: AND RIC_CODE = 'LIN';
38976: COMMIT;
38977: L_LINE_ID.DELETE;

Line 39016: L_STMT := 'SELECT MIN(RGP_ID),MAX(RGP_ID)FROM (SELECT /+ PARALLEL(L) / RGP_ID ,FLOOR(SUM(COUNT(*)) OVER (ORDER BY RGP_ID ROWS UNBOUNDED PRECEDING)/ :1 ) BUCKET FROM OKS_RULE_UPGRADE L GROUP BY RGP_ID) GROUP BY BUCKET';

39012: IF(P_BUCKET_VALUE = 0) THEN
39013: P_BUCKET_VALUE := 1;
39014: END IF;
39015:
39016: L_STMT := 'SELECT MIN(RGP_ID),MAX(RGP_ID)FROM (SELECT /*+ PARALLEL(L) */ RGP_ID ,FLOOR(SUM(COUNT(*)) OVER (ORDER BY RGP_ID ROWS UNBOUNDED PRECEDING)/ :1 ) BUCKET FROM OKS_RULE_UPGRADE L GROUP BY RGP_ID) GROUP BY BUCKET';
39017:
39018: I:=0;
39019:
39020: OPEN L_UPGRD_CSR FOR L_STMT USING P_BUCKET_VALUE ;