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

Line 102: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

98: - get_product_tax_info
99: - get get_party_tax_info
100:
101: PROCEDURE get_tax_info_from_item(
102: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
103: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
104: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
105: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
106: p_return_status OUT NOCOPY VARCHAR2,

Line 103: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,

99: - get get_party_tax_info
100:
101: PROCEDURE get_tax_info_from_item(
102: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
103: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
104: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
105: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
106: p_return_status OUT NOCOPY VARCHAR2,
107: p_error_buffer OUT NOCOPY VARCHAR2);

Line 4602: FROM MTL_SYSTEM_ITEMS

4598: 8192);
4599: BEGIN
4600: SELECT item_type
4601: INTO l_trx_alphanumeric_value
4602: FROM MTL_SYSTEM_ITEMS
4603: WHERE inventory_item_id = ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ID(p_structure_index)
4604: AND organization_id = nvl(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ORG_ID(p_structure_index),
4605: p_event_class_rec.internal_organization_id);
4606: EXCEPTION

Line 6238: -- get taxable_flag or tax_code from mtl_system_items

6234: RETURN;
6235: END IF;
6236:
6237: --
6238: -- get taxable_flag or tax_code from mtl_system_items
6239: --
6240: get_tax_info_from_item(l_product_id,
6241: l_item_org_id,
6242: p_determining_factor_code,

Line 6276: -- mtl_system_items table depending on the determining factor code passed in

6272: -- get_tax_info_from_item
6273: --
6274: -- DESCRIPTION
6275: -- This procedure returns taxable_flag or tax_code obtained from
6276: -- mtl_system_items table depending on the determining factor code passed in
6277: --
6278:
6279: PROCEDURE get_tax_info_from_item(
6280: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

Line 6280: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

6276: -- mtl_system_items table depending on the determining factor code passed in
6277: --
6278:
6279: PROCEDURE get_tax_info_from_item(
6280: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6281: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
6282: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6283: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6284: p_return_status OUT NOCOPY VARCHAR2,

Line 6281: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,

6277: --
6278:
6279: PROCEDURE get_tax_info_from_item(
6280: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6281: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
6282: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6283: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6284: p_return_status OUT NOCOPY VARCHAR2,
6285: p_error_buffer OUT NOCOPY VARCHAR2)

Line 6289: (c_product_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

6285: p_error_buffer OUT NOCOPY VARCHAR2)
6286:
6287: IS
6288: CURSOR get_tax_code_csr
6289: (c_product_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6290: c_item_org_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE)
6291: IS
6292: SELECT TAX_CODE
6293: FROM MTL_SYSTEM_ITEMS

Line 6290: c_item_org_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE)

6286:
6287: IS
6288: CURSOR get_tax_code_csr
6289: (c_product_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6290: c_item_org_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE)
6291: IS
6292: SELECT TAX_CODE
6293: FROM MTL_SYSTEM_ITEMS
6294: WHERE INVENTORY_ITEM_ID = c_product_id AND

Line 6293: FROM MTL_SYSTEM_ITEMS

6289: (c_product_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6290: c_item_org_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE)
6291: IS
6292: SELECT TAX_CODE
6293: FROM MTL_SYSTEM_ITEMS
6294: WHERE INVENTORY_ITEM_ID = c_product_id AND
6295: ORGANIZATION_ID = c_item_org_id;
6296:
6297: BEGIN