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_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on MTL_SYSTEM_ITEMS

Line 238: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

234: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
235: p_concatenated_segments IN varchar2,
236: p_templ_tax_classification_cd IN varchar2,
237: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
238: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
239: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
240: p_item_org_id IN mtl_system_items.organization_id%TYPE,
241: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
242: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 239: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

235: p_concatenated_segments IN varchar2,
236: p_templ_tax_classification_cd IN varchar2,
237: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
238: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
239: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
240: p_item_org_id IN mtl_system_items.organization_id%TYPE,
241: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
242: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
243: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,

Line 240: p_item_org_id IN mtl_system_items.organization_id%TYPE,

236: p_templ_tax_classification_cd IN varchar2,
237: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
238: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
239: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
240: p_item_org_id IN mtl_system_items.organization_id%TYPE,
241: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
242: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
243: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
244: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,

Line 324: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

320: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
321: p_concatenated_segments IN varchar2,
322: p_templ_tax_classification_cd IN varchar2,
323: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
324: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
325: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
326: p_item_org_id IN mtl_system_items.organization_id%TYPE,
327: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
328: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 325: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

321: p_concatenated_segments IN varchar2,
322: p_templ_tax_classification_cd IN varchar2,
323: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
324: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
325: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
326: p_item_org_id IN mtl_system_items.organization_id%TYPE,
327: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
328: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
329: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,

Line 326: p_item_org_id IN mtl_system_items.organization_id%TYPE,

322: p_templ_tax_classification_cd IN varchar2,
323: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
324: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
325: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
326: p_item_org_id IN mtl_system_items.organization_id%TYPE,
327: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
328: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
329: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
330: FUNC_SHORT_NAME IN VARCHAR2,

Line 412: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

408: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
409: p_concatenated_segments IN varchar2,
410: p_templ_tax_classification_cd IN varchar2,
411: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
412: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
413: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
414: p_item_org_id IN mtl_system_items.organization_id%TYPE,
415: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
416: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 413: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

409: p_concatenated_segments IN varchar2,
410: p_templ_tax_classification_cd IN varchar2,
411: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
412: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
413: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
414: p_item_org_id IN mtl_system_items.organization_id%TYPE,
415: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
416: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
417: p_tax_user_override_flag IN VARCHAR2,

Line 414: p_item_org_id IN mtl_system_items.organization_id%TYPE,

410: p_templ_tax_classification_cd IN varchar2,
411: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
412: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
413: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
414: p_item_org_id IN mtl_system_items.organization_id%TYPE,
415: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
416: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
417: p_tax_user_override_flag IN VARCHAR2,
418: p_user_tax_name IN VARCHAR2,

Line 442: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,

438: l_count NUMBER;
439: l_return_status VARCHAR2(80);
440:
441: CURSOR sel_item_taxable_flag
442: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
443: c_item_org_id mtl_system_items_b.organization_id%TYPE,
444: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
445:
446: SELECT taxable_flag

Line 443: c_item_org_id mtl_system_items_b.organization_id%TYPE,

439: l_return_status VARCHAR2(80);
440:
441: CURSOR sel_item_taxable_flag
442: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
443: c_item_org_id mtl_system_items_b.organization_id%TYPE,
444: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
445:
446: SELECT taxable_flag
447: FROM mtl_system_items si

Line 444: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS

440:
441: CURSOR sel_item_taxable_flag
442: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
443: c_item_org_id mtl_system_items_b.organization_id%TYPE,
444: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
445:
446: SELECT taxable_flag
447: FROM mtl_system_items si
448: WHERE si.inventory_item_id = c_inventory_item_id

Line 447: FROM mtl_system_items si

443: c_item_org_id mtl_system_items_b.organization_id%TYPE,
444: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
445:
446: SELECT taxable_flag
447: FROM mtl_system_items si
448: WHERE si.inventory_item_id = c_inventory_item_id
449: AND si.organization_id = nvl(c_ship_to_loc_org_id, c_item_org_id);
450:
451: CURSOR c_evnt_cls_options (c_org_id NUMBER,

Line 1397: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

1393: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
1394: p_concatenated_segments IN varchar2,
1395: p_templ_tax_classification_cd IN varchar2,
1396: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
1397: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
1398: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
1399: p_item_org_id IN mtl_system_items.organization_id%TYPE,
1400: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
1401: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 1398: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

1394: p_concatenated_segments IN varchar2,
1395: p_templ_tax_classification_cd IN varchar2,
1396: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
1397: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
1398: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
1399: p_item_org_id IN mtl_system_items.organization_id%TYPE,
1400: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
1401: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
1402: p_tax_user_override_flag IN VARCHAR2,

Line 1399: p_item_org_id IN mtl_system_items.organization_id%TYPE,

1395: p_templ_tax_classification_cd IN varchar2,
1396: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
1397: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
1398: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
1399: p_item_org_id IN mtl_system_items.organization_id%TYPE,
1400: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
1401: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
1402: p_tax_user_override_flag IN VARCHAR2,
1403: p_user_tax_name IN VARCHAR2,

Line 2134: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

2130: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
2131: p_concatenated_segments IN varchar2,
2132: p_templ_tax_classification_cd IN varchar2,
2133: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
2134: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2135: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
2136: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2137: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
2138: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 2135: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

2131: p_concatenated_segments IN varchar2,
2132: p_templ_tax_classification_cd IN varchar2,
2133: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
2134: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2135: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
2136: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2137: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
2138: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
2139: p_tax_user_override_flag IN VARCHAR2 DEFAULT 'N',

Line 2136: p_item_org_id IN mtl_system_items.organization_id%TYPE,

2132: p_templ_tax_classification_cd IN varchar2,
2133: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
2134: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2135: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
2136: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2137: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
2138: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
2139: p_tax_user_override_flag IN VARCHAR2 DEFAULT 'N',
2140: p_user_tax_name IN VARCHAR2 DEFAULT NULL,

Line 2165: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,

2161: l_count NUMBER;
2162: l_return_status VARCHAR2(80);
2163:
2164: CURSOR sel_item_taxable_flag
2165: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
2166: c_item_org_id mtl_system_items_b.organization_id%TYPE,
2167: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
2168:
2169: SELECT taxable_flag

Line 2166: c_item_org_id mtl_system_items_b.organization_id%TYPE,

2162: l_return_status VARCHAR2(80);
2163:
2164: CURSOR sel_item_taxable_flag
2165: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
2166: c_item_org_id mtl_system_items_b.organization_id%TYPE,
2167: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
2168:
2169: SELECT taxable_flag
2170: FROM mtl_system_items si

Line 2167: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS

2163:
2164: CURSOR sel_item_taxable_flag
2165: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
2166: c_item_org_id mtl_system_items_b.organization_id%TYPE,
2167: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
2168:
2169: SELECT taxable_flag
2170: FROM mtl_system_items si
2171: WHERE si.inventory_item_id = c_inventory_item_id

Line 2170: FROM mtl_system_items si

2166: c_item_org_id mtl_system_items_b.organization_id%TYPE,
2167: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
2168:
2169: SELECT taxable_flag
2170: FROM mtl_system_items si
2171: WHERE si.inventory_item_id = c_inventory_item_id
2172: AND si.organization_id = nvl(c_ship_to_loc_org_id, c_item_org_id);
2173:
2174: CURSOR c_evnt_cls_options (c_org_id NUMBER,

Line 2727: p_item_id IN mtl_system_items.inventory_item_id%TYPE,

2723: -------------------------------------------------------------------------------
2724:
2725:
2726: FUNCTION get_item_tax (
2727: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
2728: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2729: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2730: p_calling_sequence IN varchar2 )
2731:

Line 2728: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

2724:
2725:
2726: FUNCTION get_item_tax (
2727: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
2728: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2729: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2730: p_calling_sequence IN varchar2 )
2731:
2732: RETURN VARCHAR2 IS

Line 2729: p_item_org_id IN mtl_system_items.organization_id%TYPE,

2725:
2726: FUNCTION get_item_tax (
2727: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
2728: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2729: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2730: p_calling_sequence IN varchar2 )
2731:
2732: RETURN VARCHAR2 IS
2733: l_curr_calling_sequence VARCHAR2(2000);

Line 2739: mtl_system_items si

2735:
2736: CURSOR sel_item_tax IS
2737: SELECT si.purchasing_tax_code
2738: FROM fnd_lookups tc,
2739: mtl_system_items si
2740: WHERE si.inventory_item_id = p_item_id
2741: AND si.organization_id = nvl(p_ship_to_loc_org_id, p_item_org_id)
2742: AND tc.lookup_code = si.purchasing_tax_code
2743: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'