APPS.ZX_ZXARRECV_XMLP_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 59: ZX_REP_TRX_DETAIL_T DET

55: COUNT(1)
56: INTO CP_TRL_ROW_COUNT
57: FROM
58: ZX_REP_CONTEXT_T CON,
59: ZX_REP_TRX_DETAIL_T DET
60: WHERE CON.REQUEST_ID = P_CONC_REQUEST_ID
61: AND DET.REQUEST_ID = CON.REQUEST_ID
62: AND NVL(DET.REP_CONTEXT_ID
63: ,CON.REP_CONTEXT_ID) = CON.REP_CONTEXT_ID;

Line 370: LP_FROM_CLAUSE := ' ZX_REP_TRX_DETAIL_T DET1 ';

366: LP_DOC_SEQUENCE_ORDER := 'NULL';
367: IF P_REPORT_NAME = 'ZXCOARSW' THEN
368: LP_CM_BATCH_SOURCE_NAME := 'DET1.trx_batch_source_name';
369: LP_CM_TRX_NUMBER := 'DET1.trx_number';
370: LP_FROM_CLAUSE := ' ZX_REP_TRX_DETAIL_T DET1 ';
371: LP_REPORT_WHERE := 'DET1.request_id = DET.request_id and rownum <=10 and ';
372: ELSIF P_REPORT_NAME = 'ZXCLRSLL' THEN
373: LP_DOC_SEQUENCE_ORDER := 'DECODE(EXT.GDF_RA_CUST_TRX_ATT19,
374: NULL, EXT.GDF_RA_CUST_TRX_TYPES_ATT5,

Line 376: LP_FROM_CLAUSE := ', ZX_REP_TRX_DETAIL_T DET1,

372: ELSIF P_REPORT_NAME = 'ZXCLRSLL' THEN
373: LP_DOC_SEQUENCE_ORDER := 'DECODE(EXT.GDF_RA_CUST_TRX_ATT19,
374: NULL, EXT.GDF_RA_CUST_TRX_TYPES_ATT5,
375: EXT1.GDF_RX_CUST_TRX_TYPES_ATT5)';
376: LP_FROM_CLAUSE := ', ZX_REP_TRX_DETAIL_T DET1,
377: ZX_REP_TRX_JX_EXT_T EXT1';
378: LP_REPORT_WHERE := ' DET1.request_id = DET.request_id
379: AND DET1.applied_to_trx_line_id(+) = DET.trx_line_id
380: AND EXT.gdf_ra_cust_trx_att9 = DET1.trx_type_id

Line 550: ZX_REP_TRX_DETAIL_T A

546: SELECT
547: SUM(A.TAXABLE_AMT)
548: INTO L_INV_TAXABLE_AMT
549: FROM
550: ZX_REP_TRX_DETAIL_T A
551: WHERE A.TRX_ID = C_TRANSACTION_ID
552: AND A.TRX_LINE_ID = C_TRANSACTION_LINE
553: AND A.REQUEST_ID = P_CONC_REQUEST_ID
554: AND A.ROWID = (

Line 558: ZX_REP_TRX_DETAIL_T B

554: AND A.ROWID = (
555: SELECT
556: MIN(B.ROWID)
557: FROM
558: ZX_REP_TRX_DETAIL_T B
559: WHERE A.TRX_ID = B.TRX_ID
560: AND A.TRX_LINE_ID = B.TRX_LINE_ID
561: AND B.REQUEST_ID = P_CONC_REQUEST_ID );
562: ELSE

Line 589: ZX_REP_TRX_DETAIL_T A

585: SELECT
586: SUM(A.TAXABLE_AMT_FUNCL_CURR)
587: INTO L_INV_TAXABLE_AMT
588: FROM
589: ZX_REP_TRX_DETAIL_T A
590: WHERE A.TRX_ID = C_TRANSACTION_ID
591: AND A.TRX_LINE_ID = C_TRANSACTION_LINE
592: AND A.REQUEST_ID = P_CONC_REQUEST_ID
593: AND A.ROWID = (

Line 597: ZX_REP_TRX_DETAIL_T B

593: AND A.ROWID = (
594: SELECT
595: MIN(B.ROWID)
596: FROM
597: ZX_REP_TRX_DETAIL_T B
598: WHERE A.TRX_ID = B.TRX_ID
599: AND A.TRX_LINE_ID = B.TRX_LINE_ID
600: AND B.REQUEST_ID = P_CONC_REQUEST_ID );
601: SELECT

Line 610: ZX_REP_TRX_DETAIL_T A

606: ,0) + NVL(A.TAX_AMT_FUNCL_CURR
607: ,0))
608: INTO CF_TOT_AMOUNT,CF_TOT_FUNC_AMT
609: FROM
610: ZX_REP_TRX_DETAIL_T A
611: WHERE A.TRX_ID = C_TRANSACTION_ID
612: AND A.TRX_LINE_ID = C_TRANSACTION_LINE
613: AND A.REQUEST_ID = P_CONC_REQUEST_ID
614: AND A.ROWID = (

Line 618: ZX_REP_TRX_DETAIL_T B

614: AND A.ROWID = (
615: SELECT
616: MIN(B.ROWID)
617: FROM
618: ZX_REP_TRX_DETAIL_T B
619: WHERE A.TRX_ID = B.TRX_ID
620: AND A.TRX_LINE_ID = B.TRX_LINE_ID
621: AND B.REQUEST_ID = P_CONC_REQUEST_ID );
622: ELSE