DBA Data[Home] [Help]

APPS.ZX_ZXAPJAJL_XMLP_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 25: ZX_REP_TRX_DETAIL_T DET

21: COUNT(1)
22: INTO CP_TRL_ROW_COUNT
23: FROM
24: ZX_REP_CONTEXT_T CON,
25: ZX_REP_TRX_DETAIL_T DET
26: WHERE CON.REQUEST_ID = P_CONC_REQUEST_ID
27: AND DET.REQUEST_ID = CON.REQUEST_ID
28: AND NVL(DET.REP_CONTEXT_ID
29: ,CON.REP_CONTEXT_ID) = CON.REP_CONTEXT_ID;

Line 410: ZX_REP_TRX_DETAIL_T A

406: SELECT
407: SUM(A.TAXABLE_AMT)
408: INTO L_INV_TAXABLE_AMT
409: FROM
410: ZX_REP_TRX_DETAIL_T A
411: WHERE A.TRX_ID = C_INVOICE_ID
412: AND A.TRX_LINE_ID = C_TRANSACTION_LINE
413: AND A.REQUEST_ID = P_CONC_REQUEST_ID
414: AND A.ROWID = (

Line 418: ZX_REP_TRX_DETAIL_T B

414: AND A.ROWID = (
415: SELECT
416: MIN(B.ROWID)
417: FROM
418: ZX_REP_TRX_DETAIL_T B
419: WHERE A.TRX_ID = B.TRX_ID
420: AND A.TRX_LINE_ID = B.TRX_LINE_ID
421: AND B.REQUEST_ID = P_CONC_REQUEST_ID );
422: ELSE

Line 449: ZX_REP_TRX_DETAIL_T A

445: SELECT
446: SUM(A.TAXABLE_AMT_FUNCL_CURR)
447: INTO L_INV_TAXABLE_AMT
448: FROM
449: ZX_REP_TRX_DETAIL_T A
450: WHERE A.TRX_ID = C_INVOICE_ID
451: AND A.TRX_LINE_ID = C_TRANSACTION_LINE
452: AND A.REQUEST_ID = P_CONC_REQUEST_ID
453: AND A.ROWID = (

Line 457: ZX_REP_TRX_DETAIL_T B

453: AND A.ROWID = (
454: SELECT
455: MIN(B.ROWID)
456: FROM
457: ZX_REP_TRX_DETAIL_T B
458: WHERE A.TRX_ID = B.TRX_ID
459: AND A.TRX_LINE_ID = B.TRX_LINE_ID
460: AND B.REQUEST_ID = P_CONC_REQUEST_ID );
461: SELECT

Line 470: ZX_REP_TRX_DETAIL_T A

466: ,0) + NVL(A.TAX_AMT_FUNCL_CURR
467: ,0))
468: INTO CF_TOT_AMOUNT,CF_TOT_FUNC_AMT
469: FROM
470: ZX_REP_TRX_DETAIL_T A
471: WHERE A.TRX_ID = C_INVOICE_ID
472: AND A.TRX_LINE_ID = C_TRANSACTION_LINE
473: AND A.REQUEST_ID = P_CONC_REQUEST_ID
474: AND A.ROWID = (

Line 478: ZX_REP_TRX_DETAIL_T B

474: AND A.ROWID = (
475: SELECT
476: MIN(B.ROWID)
477: FROM
478: ZX_REP_TRX_DETAIL_T B
479: WHERE A.TRX_ID = B.TRX_ID
480: AND A.TRX_LINE_ID = B.TRX_LINE_ID
481: AND B.REQUEST_ID = P_CONC_REQUEST_ID );
482: ELSE