APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on MTL_SYSTEM_ITEMS

Line 54: p_item_id IN mtl_system_items.inventory_item_id%TYPE,

50: p_trx_date IN ra_customer_trx.trx_date%TYPE )
51: RETURN VARCHAR2;
52:
53: FUNCTION get_item_tax(
54: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
55: p_organization_id IN mtl_system_items.organization_id%TYPE,
56: p_trx_date IN DATE,
57: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null)
58: RETURN VARCHAR2;

Line 55: p_organization_id IN mtl_system_items.organization_id%TYPE,

51: RETURN VARCHAR2;
52:
53: FUNCTION get_item_tax(
54: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
55: p_organization_id IN mtl_system_items.organization_id%TYPE,
56: p_trx_date IN DATE,
57: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null)
58: RETURN VARCHAR2;
59: /*******

Line 1781: p_item_id IN mtl_system_items.inventory_item_id%TYPE,

1777: | 23-Jun-04 Sudhir Sekuri Bugfix 3611046 |
1778: *----------------------------------------------------------------------------*/
1779:
1780: FUNCTION get_item_tax (
1781: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
1782: p_organization_id IN mtl_system_items.organization_id%TYPE,
1783: p_trx_date IN DATE,
1784: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null
1785: ) RETURN VARCHAR2 IS

Line 1782: p_organization_id IN mtl_system_items.organization_id%TYPE,

1778: *----------------------------------------------------------------------------*/
1779:
1780: FUNCTION get_item_tax (
1781: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
1782: p_organization_id IN mtl_system_items.organization_id%TYPE,
1783: p_trx_date IN DATE,
1784: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null
1785: ) RETURN VARCHAR2 IS
1786:

Line 1811: (c_item_id MTL_SYSTEM_ITEMS.inventory_item_id%type,

1807: AND rownum = 1
1808: ORDER BY l.org_id desc;
1809:
1810: CURSOR sel_item_tax
1811: (c_item_id MTL_SYSTEM_ITEMS.inventory_item_id%type,
1812: c_organization_id MTL_SYSTEM_ITEMS.organization_id%type,
1813: c_trx_date DATE,
1814: c_org_id NUMBER)
1815: IS

Line 1812: c_organization_id MTL_SYSTEM_ITEMS.organization_id%type,

1808: ORDER BY l.org_id desc;
1809:
1810: CURSOR sel_item_tax
1811: (c_item_id MTL_SYSTEM_ITEMS.inventory_item_id%type,
1812: c_organization_id MTL_SYSTEM_ITEMS.organization_id%type,
1813: c_trx_date DATE,
1814: c_org_id NUMBER)
1815: IS
1816: SELECT i.tax_code

Line 1817: -- FROM fnd_lookups l, MTL_SYSTEM_ITEMS bug#4574838

1813: c_trx_date DATE,
1814: c_org_id NUMBER)
1815: IS
1816: SELECT i.tax_code
1817: -- FROM fnd_lookups l, MTL_SYSTEM_ITEMS bug#4574838
1818: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i
1819: WHERE i.inventory_item_id = c_item_id
1820: AND i.organization_id = c_organization_id
1821: AND l.lookup_code = i.tax_code

Line 1818: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i

1814: c_org_id NUMBER)
1815: IS
1816: SELECT i.tax_code
1817: -- FROM fnd_lookups l, MTL_SYSTEM_ITEMS bug#4574838
1818: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i
1819: WHERE i.inventory_item_id = c_item_id
1820: AND i.organization_id = c_organization_id
1821: AND l.lookup_code = i.tax_code
1822: AND l.org_id IN (c_org_id, -99)