APPS.ZX_SRVC_TYP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 7953: l_item_name MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE; --Bug 10179680

7949: l_return_status VARCHAR2(30);
7950: l_tax_prof_id NUMBER;
7951: l_partytype VARCHAR2(100);
7952: l_context_info_rec ZX_API_PUB.context_info_rec_type;
7953: l_item_name MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE; --Bug 10179680
7954: l_org_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE; --Bug 10179680
7955:
7956: BEGIN
7957: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 8478: FROM MTL_SYSTEM_ITEMS

8474: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_code(p_trx_line_index) is NULL THEN
8475: BEGIN
8476: SELECT segment1
8477: INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_code(p_trx_line_index)
8478: FROM MTL_SYSTEM_ITEMS
8479: WHERE inventory_item_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_id(p_trx_line_index)
8480: AND organization_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_org_id(p_trx_line_index);
8481: EXCEPTION WHEN OTHERS THEN
8482: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 8505: FROM MTL_SYSTEM_ITEMS_B_KFV MSIBK

8501:
8502: BEGIN
8503: SELECT MSIBK.CONCATENATED_SEGMENTS ITEM_NAME
8504: INTO L_ITEM_NAME
8505: FROM MTL_SYSTEM_ITEMS_B_KFV MSIBK
8506: WHERE MSIBK.INVENTORY_ITEM_ID=ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_id(p_trx_line_index)
8507: AND ROWNUM=1;
8508:
8509: EXCEPTION