APPS.CSI_MASS_EDIT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 4969: FROM mtl_system_items_b

4965: --Retrieving serial control code
4966: BEGIN
4967: SELECT SERIAL_NUMBER_CONTROL_CODE
4968: INTO l_serial_number_control_code
4969: FROM mtl_system_items_b
4970: WHERE INVENTORY_ITEM_ID = l_instance.ITEM_ID
4971: AND ORGANIZATION_ID = l_last_vld_organization_id;
4972: EXCEPTION
4973: when no_data_found then

Line 6255: FROM mtl_system_items_kfv m2,

6251: BEGIN
6252: UPDATE csi_webadi_staging cws SET ITEM_ID =
6253: (
6254: SELECT m2.inventory_item_id
6255: FROM mtl_system_items_kfv m2,
6256: mtl_system_items m1,
6257: fnd_lookup_values fcl,
6258: mtl_parameters m3
6259: WHERE m1.COMMS_NL_TRACKABLE_FLAG = 'Y'

Line 6256: mtl_system_items m1,

6252: UPDATE csi_webadi_staging cws SET ITEM_ID =
6253: (
6254: SELECT m2.inventory_item_id
6255: FROM mtl_system_items_kfv m2,
6256: mtl_system_items m1,
6257: fnd_lookup_values fcl,
6258: mtl_parameters m3
6259: WHERE m1.COMMS_NL_TRACKABLE_FLAG = 'Y'
6260: and sysdate between nvl(m1.START_DATE_ACTIVE,sysdate)

Line 6472: mtl_system_items_kfv mtl, okc_k_headers_all_b okh

6468: UPDATE csi_webadi_staging cws SET ASSOCIATE_SERVICE_LINE_ID =
6469: (
6470: SELECT okl.id
6471: FROM okc_k_lines_b okl, okc_k_items oki,
6472: mtl_system_items_kfv mtl, okc_k_headers_all_b okh
6473: WHERE oki.cle_id = okl.id
6474: AND mtl.inventory_item_id = oki.object1_id1
6475: AND mtl.organization_id = oki.object1_id2
6476: AND oki.jtot_object1_code = 'OKX_SERVICE'