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.CE_CEPURGE_XMLP_PKG dependencies on CE_STATEMENT_LINES

Line 51: CE_STATEMENT_LINES SL,

47: SELECT
48: 1
49: FROM
50: CE_STATEMENT_HEADERS SH,
51: CE_STATEMENT_LINES SL,
52: CE_STATEMENT_RECONCILS_ALL SR
53: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
54: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
55: AND SH.STATEMENT_HEADER_ID = CSH.STATEMENT_HEADER_ID

Line 84: CE_STATEMENT_LINES CSL

80: CURSOR C_PURGE_LINES IS
81: SELECT
82: CSL.STATEMENT_LINE_ID
83: FROM
84: CE_STATEMENT_LINES CSL
85: WHERE CSL.STATEMENT_HEADER_ID = X_HEADER_ID;
86: CURSOR C_PURGE_INTRA_HEADERS IS
87: SELECT
88: CSH.STATEMENT_HEADER_ID

Line 460: CE_STATEMENT_LINES SL,

456: SELECT
457: 1
458: FROM
459: CE_STATEMENT_HEADERS SH,
460: CE_STATEMENT_LINES SL,
461: CE_STATEMENT_RECONCILS_ALL SR
462: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
463: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
464: AND SH.STATEMENT_HEADER_ID = CSH.STATEMENT_HEADER_ID

Line 586: CE_STATEMENT_LINES SL,

582: SELECT
583: 1
584: FROM
585: CE_STATEMENT_HEADERS SH,
586: CE_STATEMENT_LINES SL,
587: CE_STATEMENT_RECONCILS_ALL SR
588: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
589: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
590: AND SH.STATEMENT_HEADER_ID = CSH.STATEMENT_HEADER_ID

Line 711: CE_STATEMENT_LINES SL,

707: SELECT
708: 1
709: FROM
710: CE_STATEMENT_HEADERS SH,
711: CE_STATEMENT_LINES SL,
712: CE_STATEMENT_RECONCILS_ALL SR
713: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
714: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
715: AND SH.STATEMENT_HEADER_ID = CSH.STATEMENT_HEADER_ID

Line 818: CE_STATEMENT_LINES

814: LAST_UPDATED_BY,
815: LAST_UPDATE_DATE,
816: RECONCILE_TO_STATEMENT_FLAG
817: FROM
818: CE_STATEMENT_LINES
819: WHERE STATEMENT_HEADER_ID IN (
820: SELECT
821: STATEMENT_HEADER_ID
822: FROM

Line 913: DELETE FROM CE_STATEMENT_LINES

909: INTO
910: X_LINE_ID;
911: LOOP
912: EXIT WHEN C_PURGE_LINES%NOTFOUND;
913: DELETE FROM CE_STATEMENT_LINES
914: WHERE STATEMENT_HEADER_ID = X_HEADER_ID;
915: PURGE_LINES := PURGE_LINES + SQL%ROWCOUNT;
916: DELETE FROM CE_STATEMENT_RECONCILS_ALL
917: WHERE STATEMENT_LINE_ID = X_LINE_ID

Line 1149: CE_STATEMENT_LINES_INTERFACE CSL

1145: CHARGES_AMOUNT,
1146: CURRENCY_CODE,
1147: USER_EXCHANGE_RATE_TYPE
1148: FROM
1149: CE_STATEMENT_LINES_INTERFACE CSL
1150: WHERE CSL.BANK_ACCOUNT_NUM IN (
1151: SELECT
1152: BANK_ACCOUNT_NUM
1153: FROM

Line 1165: DELETE FROM CE_STATEMENT_LINES_INTERFACE CSL

1161: AND NVL(INTRA_DAY_FLAG
1162: ,'N') = 'N' );
1163: C_ARCHIVE_INF_LINES := SQL%ROWCOUNT;
1164: END IF;
1165: DELETE FROM CE_STATEMENT_LINES_INTERFACE CSL
1166: WHERE CSL.STATEMENT_NUMBER || '-' || CSL.BANK_ACCOUNT_NUM IN (
1167: SELECT
1168: CSH.STATEMENT_NUMBER || '-' || CSH.BANK_ACCOUNT_NUM
1169: FROM

Line 1875: CE_STATEMENT_LINES_INTERFACE CSL

1871: CHARGES_AMOUNT,
1872: CURRENCY_CODE,
1873: USER_EXCHANGE_RATE_TYPE
1874: FROM
1875: CE_STATEMENT_LINES_INTERFACE CSL
1876: WHERE CSL.BANK_ACCOUNT_NUM IN (
1877: SELECT
1878: BANK_ACCOUNT_NUM
1879: FROM

Line 1890: DELETE FROM CE_STATEMENT_LINES_INTERFACE CSL

1886: WHERE CSL.BANK_ACCOUNT_NUM = BANK_ACCOUNT_NUM
1887: AND INTRA_DAY_FLAG = 'Y' );
1888: C_ARCHIVE_INF_LINES2 := SQL%ROWCOUNT;
1889: END IF;
1890: DELETE FROM CE_STATEMENT_LINES_INTERFACE CSL
1891: WHERE CSL.STATEMENT_NUMBER || '-' || CSL.BANK_ACCOUNT_NUM IN (
1892: SELECT
1893: CSH.STATEMENT_NUMBER || '-' || CSH.BANK_ACCOUNT_NUM
1894: FROM