APPS.CST_EAMCOST_PUB dependencies on MTL_SERIAL_NUMBERS

Line 5337: -- find out object_id from MTL_SERIAL_NUMBERS

5333: l_statement := 30;
5334: x_return_status := fnd_api.g_ret_sts_success;
5335:
5336: ------------------------------------------------
5337: -- find out object_id from MTL_SERIAL_NUMBERS
5338: -- using inventory_item_id
5339: -- and serial number
5340: ------------------------------------------------
5341: l_statement := 40;

Line 5344: FROM mtl_serial_numbers

5340: ------------------------------------------------
5341: l_statement := 40;
5342: SELECT gen_object_id, current_organization_id
5343: INTO l_gen_object_id, l_org_id
5344: FROM mtl_serial_numbers
5345: WHERE inventory_item_id = p_inventory_item_id
5346: AND serial_number = p_serial_number;
5347:
5348: l_statement := 45;

Line 5668: mtl_serial_numbers msn,

5664: 1,
5665: NULL,
5666: NULL
5667: FROM cst_eam_asset_per_balances ceapb,
5668: mtl_serial_numbers msn,
5669: --Bug#16095661: Distinct group_id, object
5670: (select DISTINCT group_id, object_id
5671: from cst_eam_hierarchy_snapshot
5672: where group_id = x_group_id ) cehs

Line 8548: mtl_serial_numbers msn,

8544: cii.serial_number,
8545: msn.gen_object_id
8546: from csi_item_instances cii,
8547: eam_work_order_route ewor,
8548: mtl_serial_numbers msn,
8549: wip_discrete_jobs wdj
8550: where wdj.organization_id = p_org_id
8551: and ewor.wip_entity_id = p_wip_entity_id
8552: and ewor.wip_entity_id = wdj.wip_entity_id

Line 8969: x_maintenance_object_id OUT NOCOPY mtl_serial_numbers.gen_object_id%TYPE,

8965: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8966: p_wip_entity_id IN NUMBER,
8967: x_inventory_item_id OUT NOCOPY csi_item_instances.inventory_item_id%TYPE,
8968: x_serial_number OUT NOCOPY csi_item_instances.serial_number%TYPE,
8969: x_maintenance_object_id OUT NOCOPY mtl_serial_numbers.gen_object_id%TYPE,
8970: x_return_status OUT NOCOPY VARCHAR2,
8971: x_msg_count OUT NOCOPY NUMBER,
8972: x_msg_data OUT NOCOPY VARCHAR2)
8973: IS