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.INV_EBI_ITEM_HELPER dependencies on MTL_SYSTEM_ITEMS_B

Line 258: FROM mtl_system_items_b_kfv

254: WHEN G_INVENTORY_ITEM THEN
255: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
256: l_pk2 := ID_COL_VALUE('inventory_item_id',p_pk_col_name_val_pairs);
257: SELECT concatenated_segments INTO l_code
258: FROM mtl_system_items_b_kfv
259: WHERE organization_id = l_pk1
260: AND inventory_item_id = l_pk2;
261: END CASE;
262: END IF;

Line 1558: l_curr_item_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;

1554: l_source_system_id NUMBER;
1555: l_assign_def_temp_from_icc VARCHAR2(1) := FND_API.G_FALSE;
1556: l_curr_lifecycle_id NUMBER;
1557: l_curr_phase_id NUMBER;
1558: l_curr_item_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;
1559: /* Start of Bug 13370136 */ -- ramukher
1560: l_nls_language FND_LANGUAGES.nls_language%TYPE;
1561: l_orig_nls_lang FND_LANGUAGES.nls_language%TYPE;
1562: /*End of Bug 13370136 */ -- ramukher

Line 1579: FROM mtl_system_items_b

1575: cp_org_id IN NUMBER
1576: ) IS
1577:
1578: SELECT lifecycle_id ,current_phase_id ,inventory_item_status_code
1579: FROM mtl_system_items_b
1580: WHERE inventory_item_id = cp_item_id
1581: AND organization_id = cp_org_id;
1582:
1583: /* CURSOR c_get_default_phase_id (cp_lifecycle_id IN NUMBER) IS

Line 3624: FROM mtl_system_items_b

3620: SELECT lifecycle_id,
3621: current_phase_id,
3622: inventory_item_status_code,
3623: item_catalog_group_id
3624: FROM mtl_system_items_b
3625: WHERE inventory_item_id = cp_item_id
3626: AND organization_id = cp_org_id;
3627:
3628: CURSOR c_get_phase_seq (cp_phase_id IN NUMBER ) IS

Line 3664: l_curr_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;

3660:
3661: l_curr_cc_id NUMBER;
3662: l_curr_lifecycle_id NUMBER;
3663: l_curr_phase_id NUMBER;
3664: l_curr_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;
3665: l_new_lifecycle_id NUMBER;
3666: l_new_phase_id NUMBER;
3667: l_new_cc_id NUMBER;
3668: l_new_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;

Line 3668: l_new_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;

3664: l_curr_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;
3665: l_new_lifecycle_id NUMBER;
3666: l_new_phase_id NUMBER;
3667: l_new_cc_id NUMBER;
3668: l_new_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;
3669: l_count NUMBER := 0;
3670: l_new_phase_seq NUMBER;
3671: l_curr_phase_seq NUMBER;
3672: l_allow_lcp_skip VARCHAR2(1) := NULL;

Line 4849: FROM mtl_system_items_b

4845: p_organization_id IS NOT NULL AND
4846: p_item_classification_id IS NOT NULL) THEN
4847:
4848: SELECT COUNT(1) INTO l_count
4849: FROM mtl_system_items_b
4850: WHERE
4851: inventory_item_id = p_inventory_item_id AND
4852: organization_id = p_organization_id AND
4853: item_catalog_group_id = p_item_classification_id;

Line 6509: FROM mtl_cross_references_b mcr, mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz

6505: CURSOR c_get_item_list_pim IS
6506: SELECT inv_ebi_get_operational_attrs(item_pim.inventory_item_id,item_pim.concatenated_segments,item_pim.organization_id,item_pim.organization_code,NULL,NULL)
6507: FROM
6508: (SELECT mcr.inventory_item_id, msik.concatenated_segments, msi.organization_id, mp.organization_code
6509: FROM mtl_cross_references_b mcr, mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6510: WHERE mcr.inventory_item_id = msi.inventory_item_id
6511: --AND mcr.organization_id = msi.organization_id --8897962 mcr has organization_id value as null
6512: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6513: AND hz.orig_system_id = mcr.source_system_id

Line 6550: FROM mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik

6546: CURSOR c_get_item_list IS
6547: SELECT inv_ebi_get_operational_attrs(item_npim.inventory_item_id,item_npim.concatenated_segments,item_npim.organization_id,item_npim.organization_code,NULL,NULL)
6548: FROM
6549: (SELECT msi.inventory_item_id, msik.concatenated_segments, msi.organization_id, mp.organization_code
6550: FROM mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik
6551: WHERE msi.organization_id = mp.organization_id
6552: AND msik.organization_id = msi.organization_id
6553: AND msik.inventory_item_id = msi.inventory_item_id
6554: AND msi.last_update_date <> msi.creation_date