APPS.ZX_ZXJGTAX_XMLP_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 34: ZX_REP_TRX_DETAIL_T DET

30: COUNT(1)
31: INTO CP_TRL_ROW_COUNT
32: FROM
33: ZX_REP_CONTEXT_T CON,
34: ZX_REP_TRX_DETAIL_T DET
35: WHERE CON.REQUEST_ID = P_CONC_REQUEST_ID
36: AND DET.REQUEST_ID = CON.REQUEST_ID
37: AND NVL(DET.REP_CONTEXT_ID
38: ,CON.REP_CONTEXT_ID) = CON.REP_CONTEXT_ID;

Line 171: ZX_REP_TRX_DETAIL_T A

167: SELECT
168: SUM(A.TAXABLE_AMT)
169: INTO L_INV_TAXABLE_AMT
170: FROM
171: ZX_REP_TRX_DETAIL_T A
172: WHERE A.TRX_ID = C_TRX_ID
173: AND A.TRX_LINE_ID = C_TRX_LINE_ID
174: AND A.REQUEST_ID = P_CONC_REQUEST_ID
175: AND A.ROWID = (

Line 179: ZX_REP_TRX_DETAIL_T B

175: AND A.ROWID = (
176: SELECT
177: MIN(B.ROWID)
178: FROM
179: ZX_REP_TRX_DETAIL_T B
180: WHERE A.TRX_ID = B.TRX_ID
181: AND A.TRX_LINE_ID = B.TRX_LINE_ID
182: AND B.REQUEST_ID = P_CONC_REQUEST_ID );
183: ELSE

Line 213: ZX_REP_TRX_DETAIL_T A

209: SELECT
210: SUM(A.TAXABLE_AMT_FUNCL_CURR)
211: INTO L_INV_TAXABLE_AMT
212: FROM
213: ZX_REP_TRX_DETAIL_T A
214: WHERE A.TRX_ID = C_TRX_ID
215: AND A.TRX_LINE_ID = C_TRX_LINE_ID
216: AND A.REQUEST_ID = P_CONC_REQUEST_ID
217: AND A.ROWID = (

Line 221: ZX_REP_TRX_DETAIL_T B

217: AND A.ROWID = (
218: SELECT
219: MIN(B.ROWID)
220: FROM
221: ZX_REP_TRX_DETAIL_T B
222: WHERE A.TRX_ID = B.TRX_ID
223: AND A.TRX_LINE_ID = B.TRX_LINE_ID
224: AND B.REQUEST_ID = P_CONC_REQUEST_ID );
225: ELSE