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.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_LINES

Line 1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,

1144: END ;
1145: END LOOP;
1146: END;
1147:
1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,

Line 1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,

1145: END LOOP;
1146: END;
1147:
1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,
1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,

Line 1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,

1146: END;
1147:
1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,
1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1154: p_geography_type IN VARCHAR2,

Line 1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,

1147:
1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,
1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1154: p_geography_type IN VARCHAR2,
1155: x_geography_value OUT NOCOPY VARCHAR2,

Line 1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,

1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,
1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1154: p_geography_type IN VARCHAR2,
1155: x_geography_value OUT NOCOPY VARCHAR2,
1156: x_geo_val_found OUT NOCOPY BOOLEAN) IS
1157:

Line 1376: l_place_of_supply ZX_LINES.place_of_supply_type_code%type;

1372:
1373: P_REPORT_NAME VARCHAR2(30);
1374: P_POSTING_STATUS VARCHAR2(30);
1375: P_REQUEST_ID NUMBER;
1376: l_place_of_supply ZX_LINES.place_of_supply_type_code%type;
1377: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
1378: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
1379: l_geo_val_found BOOLEAN;
1380: x_return_status VARCHAR2(1);

Line 1545: from zx_lines lines

1541: BEGIN
1542: -- Directly populate the tax line id from Base Doc on which application is done.
1543: UPDATE zx_rep_trx_detail_t dtl
1544: set dtl.tax_line_id = (select min (tax_line_id)
1545: from zx_lines lines
1546: where lines.application_id = 222
1547: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID
1548: and lines.trx_line_id = dtl.APPLIED_TO_TRX_LINE_ID
1549: and lines.tax_rate_id = dtl.tax_rate_id

Line 1561: from zx_lines lines

1557:
1558: -- Directly populate the tax line id from Adjustment Doc
1559: UPDATE zx_rep_trx_detail_t dtl
1560: set dtl.tax_line_id = (select min (tax_line_id)
1561: from zx_lines lines
1562: where lines.application_id = 222
1563: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID
1564: and lines.trx_line_id = dtl.APPLIED_TO_TRX_LINE_ID
1565: AND lines.tax_rate_id = dtl.tax_rate_id

Line 1577: from zx_lines lines

1573:
1574: /***
1575: UPDATE zx_rep_trx_detail_t dtl
1576: set tax_line_id = (select min (tax_line_id)
1577: from zx_lines lines
1578: where lines.application_id = 222
1579: and lines.trx_id = dtl.TRX_ID
1580: and lines.trx_line_id = dtl.TRX_LINE_ID)
1581: WHERE dtl.request_id = P_REQUEST_ID

Line 1733: FROM ZX_LINES_DET_FACTORS zx_det

1729: l_adj_gl_date_tbl(i),
1730: l_adj_trx_date_tbl(i),
1731: l_adj_trx_class_tbl(i),
1732: l_hq_estb_ptp_id_tbl(i)
1733: FROM ZX_LINES_DET_FACTORS zx_det
1734: WHERE zx_det.application_id = 222
1735: AND zx_det.trx_id = l_adj_trx_id_tbl(i)
1736: and zx_det.trx_line_id = Nvl(l_adj_trx_line_id_tbl(i),zx_det.trx_line_id)
1737: AND ROWNUM = 1;

Line 1742: 'Error in fetching data from ZX_LINES_DET_FACTORS for adjusted doc tax invoice date and gl date. Error Message : '

1738: EXCEPTION
1739: WHEN OTHERS THEN
1740: IF (g_level_statement>= g_current_runtime_level ) THEN
1741: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1742: 'Error in fetching data from ZX_LINES_DET_FACTORS for adjusted doc tax invoice date and gl date. Error Message : '
1743: ||substrb(SQLERRM,1,120) );
1744: END IF;
1745: END;
1746: