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 1767: p_item_id IN mtl_system_items.inventory_item_id%TYPE,

1763: | 23-Jun-04 Sudhir Sekuri Bugfix 3611046 |
1764: *----------------------------------------------------------------------------*/
1765:
1766: FUNCTION get_item_tax (
1767: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
1768: p_organization_id IN mtl_system_items.organization_id%TYPE,
1769: p_trx_date IN DATE,
1770: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null
1771: ) RETURN VARCHAR2 IS

Line 1768: p_organization_id IN mtl_system_items.organization_id%TYPE,

1764: *----------------------------------------------------------------------------*/
1765:
1766: FUNCTION get_item_tax (
1767: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
1768: p_organization_id IN mtl_system_items.organization_id%TYPE,
1769: p_trx_date IN DATE,
1770: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null
1771: ) RETURN VARCHAR2 IS
1772:

Line 1797: (c_item_id MTL_SYSTEM_ITEMS.inventory_item_id%type,

1793: AND rownum = 1
1794: ORDER BY l.org_id desc;
1795:
1796: CURSOR sel_item_tax
1797: (c_item_id MTL_SYSTEM_ITEMS.inventory_item_id%type,
1798: c_organization_id MTL_SYSTEM_ITEMS.organization_id%type,
1799: c_trx_date DATE,
1800: c_org_id NUMBER)
1801: IS

Line 1798: c_organization_id MTL_SYSTEM_ITEMS.organization_id%type,

1794: ORDER BY l.org_id desc;
1795:
1796: CURSOR sel_item_tax
1797: (c_item_id MTL_SYSTEM_ITEMS.inventory_item_id%type,
1798: c_organization_id MTL_SYSTEM_ITEMS.organization_id%type,
1799: c_trx_date DATE,
1800: c_org_id NUMBER)
1801: IS
1802: SELECT i.tax_code

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

1799: c_trx_date DATE,
1800: c_org_id NUMBER)
1801: IS
1802: SELECT i.tax_code
1803: -- FROM fnd_lookups l, MTL_SYSTEM_ITEMS bug#4574838
1804: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i
1805: WHERE i.inventory_item_id = c_item_id
1806: AND i.organization_id = c_organization_id
1807: AND l.lookup_code = i.tax_code

Line 1804: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i

1800: c_org_id NUMBER)
1801: IS
1802: SELECT i.tax_code
1803: -- FROM fnd_lookups l, MTL_SYSTEM_ITEMS bug#4574838
1804: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i
1805: WHERE i.inventory_item_id = c_item_id
1806: AND i.organization_id = c_organization_id
1807: AND l.lookup_code = i.tax_code
1808: AND l.org_id IN (c_org_id, -99)