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 232: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

228: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
229: p_concatenated_segments IN varchar2,
230: p_templ_tax_classification_cd IN varchar2,
231: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
232: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
233: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
234: p_item_org_id IN mtl_system_items.organization_id%TYPE,
235: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
236: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 233: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

229: p_concatenated_segments IN varchar2,
230: p_templ_tax_classification_cd IN varchar2,
231: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
232: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
233: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
234: p_item_org_id IN mtl_system_items.organization_id%TYPE,
235: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
236: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
237: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,

Line 234: p_item_org_id IN mtl_system_items.organization_id%TYPE,

230: p_templ_tax_classification_cd IN varchar2,
231: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
232: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
233: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
234: p_item_org_id IN mtl_system_items.organization_id%TYPE,
235: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
236: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
237: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
238: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,

Line 318: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

314: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
315: p_concatenated_segments IN varchar2,
316: p_templ_tax_classification_cd IN varchar2,
317: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
318: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
319: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
320: p_item_org_id IN mtl_system_items.organization_id%TYPE,
321: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
322: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 319: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

315: p_concatenated_segments IN varchar2,
316: p_templ_tax_classification_cd IN varchar2,
317: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
318: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
319: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
320: p_item_org_id IN mtl_system_items.organization_id%TYPE,
321: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
322: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
323: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,

Line 320: p_item_org_id IN mtl_system_items.organization_id%TYPE,

316: p_templ_tax_classification_cd IN varchar2,
317: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
318: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
319: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
320: p_item_org_id IN mtl_system_items.organization_id%TYPE,
321: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
322: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
323: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
324: FUNC_SHORT_NAME IN VARCHAR2,

Line 406: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

402: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
403: p_concatenated_segments IN varchar2,
404: p_templ_tax_classification_cd IN varchar2,
405: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
406: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
407: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
408: p_item_org_id IN mtl_system_items.organization_id%TYPE,
409: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
410: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 407: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

403: p_concatenated_segments IN varchar2,
404: p_templ_tax_classification_cd IN varchar2,
405: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
406: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
407: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
408: p_item_org_id IN mtl_system_items.organization_id%TYPE,
409: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
410: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
411: p_tax_user_override_flag IN VARCHAR2,

Line 408: p_item_org_id IN mtl_system_items.organization_id%TYPE,

404: p_templ_tax_classification_cd IN varchar2,
405: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
406: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
407: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
408: p_item_org_id IN mtl_system_items.organization_id%TYPE,
409: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
410: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
411: p_tax_user_override_flag IN VARCHAR2,
412: p_user_tax_name IN VARCHAR2,

Line 436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,

432: l_count NUMBER;
433: l_return_status VARCHAR2(80);
434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag

Line 437: c_item_org_id mtl_system_items_b.organization_id%TYPE,

433: l_return_status VARCHAR2(80);
434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag
441: FROM mtl_system_items si

Line 438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS

434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag
441: FROM mtl_system_items si
442: WHERE si.inventory_item_id = c_inventory_item_id

Line 441: FROM mtl_system_items si

437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag
441: FROM mtl_system_items si
442: WHERE si.inventory_item_id = c_inventory_item_id
443: AND si.organization_id = nvl(c_ship_to_loc_org_id, c_item_org_id);
444:
445: CURSOR c_evnt_cls_options (c_org_id NUMBER,

Line 1385: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

1381: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
1382: p_concatenated_segments IN varchar2,
1383: p_templ_tax_classification_cd IN varchar2,
1384: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
1385: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
1386: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
1387: p_item_org_id IN mtl_system_items.organization_id%TYPE,
1388: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
1389: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,

Line 1386: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

1382: p_concatenated_segments IN varchar2,
1383: p_templ_tax_classification_cd IN varchar2,
1384: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
1385: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
1386: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
1387: p_item_org_id IN mtl_system_items.organization_id%TYPE,
1388: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
1389: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
1390: p_tax_user_override_flag IN VARCHAR2,

Line 1387: p_item_org_id IN mtl_system_items.organization_id%TYPE,

1383: p_templ_tax_classification_cd IN varchar2,
1384: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
1385: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
1386: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
1387: p_item_org_id IN mtl_system_items.organization_id%TYPE,
1388: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
1389: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
1390: p_tax_user_override_flag IN VARCHAR2,
1391: p_user_tax_name IN VARCHAR2,

Line 2135: p_item_id IN mtl_system_items.inventory_item_id%TYPE,

2131: -------------------------------------------------------------------------------
2132:
2133:
2134: FUNCTION get_item_tax (
2135: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
2136: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2137: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2138: p_calling_sequence IN varchar2 )
2139:

Line 2136: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

2132:
2133:
2134: FUNCTION get_item_tax (
2135: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
2136: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2137: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2138: p_calling_sequence IN varchar2 )
2139:
2140: RETURN VARCHAR2 IS

Line 2137: p_item_org_id IN mtl_system_items.organization_id%TYPE,

2133:
2134: FUNCTION get_item_tax (
2135: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
2136: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2137: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2138: p_calling_sequence IN varchar2 )
2139:
2140: RETURN VARCHAR2 IS
2141: l_curr_calling_sequence VARCHAR2(2000);

Line 2147: mtl_system_items si

2143:
2144: CURSOR sel_item_tax IS
2145: SELECT si.purchasing_tax_code
2146: FROM fnd_lookups tc,
2147: mtl_system_items si
2148: WHERE si.inventory_item_id = p_item_id
2149: AND si.organization_id = nvl(p_ship_to_loc_org_id, p_item_org_id)
2150: AND tc.lookup_code = si.purchasing_tax_code
2151: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'