APPS.CST_EAMCOST_PUB dependencies on MTL_SERIAL_NUMBERS

Line 5114: -- find out object_id from MTL_SERIAL_NUMBERS

5110: l_statement := 30;
5111: x_return_status := fnd_api.g_ret_sts_success;
5112:
5113: ------------------------------------------------
5114: -- find out object_id from MTL_SERIAL_NUMBERS
5115: -- using inventory_item_id
5116: -- and serial number
5117: ------------------------------------------------
5118: l_statement := 40;

Line 5121: FROM mtl_serial_numbers

5117: ------------------------------------------------
5118: l_statement := 40;
5119: SELECT gen_object_id
5120: INTO l_gen_object_id
5121: FROM mtl_serial_numbers
5122: WHERE inventory_item_id = p_inventory_item_id
5123: AND serial_number = p_serial_number;
5124:
5125: l_statement := 45;

Line 5375: mtl_serial_numbers msn,

5371: 1,
5372: NULL,
5373: NULL
5374: FROM cst_eam_asset_per_balances ceapb,
5375: mtl_serial_numbers msn,
5376: cst_eam_hierarchy_snapshot cehs
5377: WHERE
5378: ceapb.inventory_item_id = msn.inventory_item_id
5379: AND ceapb.serial_number = msn.serial_number

Line 7975: mtl_serial_numbers msn,

7971: cii.serial_number,
7972: msn.gen_object_id
7973: from csi_item_instances cii,
7974: eam_work_order_route ewor,
7975: mtl_serial_numbers msn,
7976: wip_discrete_jobs wdj
7977: where wdj.organization_id = p_org_id
7978: and ewor.wip_entity_id = p_wip_entity_id
7979: and ewor.wip_entity_id = wdj.wip_entity_id

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

8392: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8393: p_wip_entity_id IN NUMBER,
8394: x_inventory_item_id OUT NOCOPY csi_item_instances.inventory_item_id%TYPE,
8395: x_serial_number OUT NOCOPY csi_item_instances.serial_number%TYPE,
8396: x_maintenance_object_id OUT NOCOPY mtl_serial_numbers.gen_object_id%TYPE,
8397: x_return_status OUT NOCOPY VARCHAR2,
8398: x_msg_count OUT NOCOPY NUMBER,
8399: x_msg_data OUT NOCOPY VARCHAR2)
8400: IS