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_B

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 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